Report average page life expectancy
The "page life expectancy" performance counter can be a good indicator of an impending performance problem. It's in the "Buffer Manager" performance object.
1
vote
Brian Donahue
shared this idea
-
Brian Donahue commented
...and there is is. Thx.
-
Hello Brian,
I think we do have this information under "Buffer cache" in SQL Server overview. If I have mis-understood this please let me know.
Thanks,
Priya