SQLTeam.com | Weblogs | Forums

Page Life Expectancy


#1

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


#2

Are the statistics up to date?


#3

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.


#4

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


#5

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: