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 ««12

PLE (Page life expectancy) revisited again. Expand / Collapse
Author
Message
Posted Friday, February 22, 2013 11:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:18 AM
Points: 246, Visits: 1,167
GilaMonster (2/22/2013)

ie, if PLE is 400, then on average a page is expected to remain in cache for 400 seconds.


Is that from the moment we measure. Or from the moment the page was last touched ?
(This makes a difference of a factor 2).

What would the PLE be in the example below ?
6 total time that a page is expected to be in the cache.
3 the remaining time that the page is expected to be in the cache.

111111|
22222|
3333|3
444|44
55|555
6|6666
|77777
|888888
|9999999
| AAAAAAA
| BBBBBBB
^
^
time
Above example only 6 pages fit in a cache. The vertical bar is the time line.
Page two gets at that moment replaced by page 8.

Cache now time_left Total_time
1 NO
2 YES 6 0 6
3 YES 5 1 6
4 YES 4 2 6
5 YES 3 3 6
6 YES 2 4 6
7 YES 1 5 6
8 YES 0 6 6
9 NO
A NO
B NO

So the average time (past) the 6 pages are in the cache is 3 seconds
And the average time (future) the 6 pages will remain in the cache is also 3 seconds.
The total time (total = past + future) that a page has remained in the cache is 6 seconds.

Maybe this wil clear up my question.
Sorry that I wasn't clear enough with my question.


Ben
Post #1423175
Posted Friday, February 22, 2013 11:19 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:46 PM
Points: 42,462, Visits: 35,525
ben.brugman (2/22/2013)
GilaMonster (2/22/2013)

ie, if PLE is 400, then on average a page is expected to remain in cache for 400 seconds.


Is that from the moment we measure. Or from the moment the page was last touched ?


If the PLE is 400, then on average a page is expected to remain in cache for a total of 400 seconds. 400 seconds from the time the page was pulled into cache until the time is is removed from cache. On average. PLE = Page Life Expectancy, the time that a page is expected to live in the cache



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1423181
Posted Friday, February 22, 2013 11:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:18 AM
Points: 246, Visits: 1,167
GilaMonster (2/22/2013)
[quote]ben.brugman (2/22/2013)
[quote]GilaMonster (2/22/2013)


If the PLE is 400, then on average a page is expected to remain in cache for a total of 400 seconds. 400 seconds from the time the page was pulled into cache until the time is is removed from cache. On average. PLE = Page Life Expectancy, the time that a page is expected to live in the cache


Thank you, that does claer it up.
(Sorry that I interpreted the term as REMAINING ple. Probably because I was associating the word expectancy with the future. Maybe a language difference.)

For the checkdb which has finished now, the PLE remained fairly stable. Around 200. Now it is going up again 318 at the moment. It is going up with 1 second for each second. But that's expected. But I still do not know if the cache was completely cleared by the dbcc checkdb.

Thanks,
Ben

Post #1423186
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse