SQLTeam.com | Weblogs | Forums

Page Life Expectancy


#1

Page Life Expectancy of SQL instance is too low - This alert is coming in my server. Why it's coming and what is the solution for this.


#2

What value is it at when it throws the alert? What's the highest it gets to during the day? How long does it stay low?

It can indicate memory pressure, but it can also just be a temporary effect of normal database maintenance that occurs after hours.


#3

i cannot show any value. Can u please say, how to resolve it.