SQLTeam.com | Weblogs | Forums

Page Life Expectancy


Page Life Expectancy of SQL instance is too low. How to resolve this.


Are the statistics up to date?


Find and fix the bad code that keeps unnecessarily driving things out of memory and get more memory. What you're seeing is a harbinger of bad news in the form of non-scalable or poorly written SQL. You should fix it before it gets worse.


I want to know is there any way to avoid this alert to come.


Yes, Like said, find and fix the code. Otherwise, just stop monitoring it because you're not using it to do what it was designed to do. :wink: