Greetings!
Page Life Expectancy is one of the 11 VitalSigns used by SQLRx to debug performance bottlenecks. |
To determine Page Life Expectancy, try the following:
Performance Monitor: Monitor the performance counter SQLServer:Buffer Manager (Page Life Expectancy) to find evidence of memory pressure. This counter records the average number of seconds that information remains in memory when it is not actively being used. If the average value is less than 300 seconds, you should look into tuning queries or possibly adding more memory.
|
