Page History
The Page Life Expectancy alert provides that is triggered when the number of seconds a page stays in the buffer pool without references has fallen is below the warning level. A decline decrease in page life expectancy can indicate an increase in the physical I/O requirements for a user database. The rate decrease could likely indicate that the memory taken away from the buffer pool is forcing database pages to exit the buffer pool prematurely.
...
Tip |
---|
To enable alerting when this metric is outside its established baseline, click select the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window. |
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...