The Memory - Page Life Expectancy alarm becomes active when the page life expectancy falls below a threshold.
A low page life expectancy indicates that SQL Server is evicting pages from the buffer cache thus reducing the value of the cache. This has the effect of requiring SQL Server to perform more disk reads. Performing extra disk reads degrades SQL Server performance.
This often has one of two causes: SQL Server has insufficient memory to work with, or SQL queries are accessing a very large number of pages in a non-sequential manner. Microsoft recommends that page life expectancy be greater than 5 minutes (300 seconds).
When the alarm is raised
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy