Grace09 (11/19/2013)

---

You can use this link http://blogs.msdn.com/b/mvpawardprogram/archive/2012/06/04/using-sys-dm-os-ring-buffers-to-diagnose-memory-issues-in-sql-server.aspx

As you can see you can only see some info that you can see at other places on your system as well. However it's a useful dynamic view.

Thank you, IgorMi. 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.

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