March 27, 2013 at 2:28 am
My Server is SQL SERVER 2012 Enterprise Edition
a few days ago I saw Page life exceptancey counter is not change
But not "0" maybe It changed once a day....
I did big table full scan but It's no use........
current value is 348,611
What's wrong???
Thanks
March 27, 2013 at 2:45 am
Page Life Expectency is a metric which gives the time duration a data page resided in data cache.
So if the size of Buffer cache is quite large then the value for PLE will definetly be large. There is nothing wrong in the metrics you are getting on your system.
If database is highly transactional in nature and/or size of Buffer Cache is relatively small then its value will change and will be less.
March 27, 2013 at 6:59 am
That value changes a lot over time. You can't look at it once and interpret anything from it. You must capture it continually. And, just because it changes doesn't mean you have a problem. It's just an indication of stuff moving out of your memory. You'll have to look at other metrics to determine if that's just a normal part of your load process or an indication of an issue.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply