GilaMonster (2/22/2013)
ben.brugman (2/22/2013)
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