Thank you, IgorMi. Since PLE is just one of performance counters. Do I need to look at other performance counter to determine the memory issue? Or as long as PLE is in good number, that's good enough? I was reading somewhere to use sys.dm_os_ring_buffers to determine the memory pressure. I don't quite understand the result from querying sys.dm_os_ring_buffers table, which make me curious. Sorry if I ask some 'silly' questions. I am kind of new to the sql server performance troubleshooting. Thanks!
IgorMi (11/19/2013)
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