Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Page life exceptancey performance couter value not change for a long time Expand / Collapse
Author
Message
Posted Wednesday, March 27, 2013 2:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 2:47 AM
Points: 2, Visits: 159
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
Post #1435796
Posted Wednesday, March 27, 2013 2:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:52 AM
Points: 5, Visits: 94
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.
Post #1435797
Posted Wednesday, March 27, 2013 6:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:16 AM
Points: 13,865, Visits: 28,261
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1435878
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse