PLE (Page life expectancy) revisited again.

 Author Message ben.brugman SSCertifiable Group: General Forum Members Points: 6144 Visits: 2458 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 ^ ^ timeAbove 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_time1 NO 2 YES 6 0 63 YES 5 1 6 4 YES 4 2 65 YES 3 3 66 YES 2 4 67 YES 1 5 6 8 YES 0 6 69 NOA NOB NOSo the average time (past) the 6 pages are in the cache is 3 secondsAnd 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 GilaMonster SSC Guru Group: General Forum Members Points: 555681 Visits: 47767 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 ShawMicrosoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enterWe stand on the bridge and no one may pass ben.brugman SSCertifiable Group: General Forum Members Points: 6144 Visits: 2458 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 cacheThank 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