Grace09 (11/19/2013)
here is the result from the query, How should I interpret it? Thanks.NodePageLifePageLife_SBufferPool_PagesBufferPool_MiBBufferPool_MiB_S
12:08:19436995359046 41867.547 0.958
000 13:30:31486311318060 10297.344 0.212
001 12:42:02457221296655 10130.117 0.222
002 9:53:55356351443304 11275.813 0.316
003 13:12:14475341301027 10164.273 0.214
PLE is just one of the many performance counters. Having PLE in 9-13 hours is just a perfect situation. With this results you don't have a memory pressure.
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com