InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 23:57:41 GMT20http://www.sqlservercentral.com/Forums/Topic1380994-391-1.aspxHi,Is there a way to detect from within SQL (i.e. not using perf mon counters) that my system is suffering from memory pressure? For example for CPU I have used sys.dm_os_ring_buffers DMV (particularly buffer type: RING_BUFFER_SCHEDULER_MONITOR) to detect CPU over-utilization if the ring_buffer sampling rate showed 3 consecutive entries above 80% utilization. Is there some way to do the same with memory?I have tried:> [b]Using sys.dm_os_ring_buffers DMV with RING_BUFFER_RESOURCE_MONITOR[/b]: Doesn't seem to be as sensitive (or accurate?) as I would like it to be, I know the box is suffering from memory issues but this DMV is not reporting anything.> [b]Using the dm_os_memory_clerks DMV (as highlighted in [url=http://technet.microsoft.com/en-us/library/cc966540.aspx#EGAA]this article[/url])[/b]: I think this particular DMV has changed since SQL 2005, and am not sure how to map the new column to the old columns mentioned in the article.Any suggestions/guidance on what I should use?, or should I abandon this concept and start looking at perf mon counters instead?Thanks!Mon, 05 Nov 2012 05:00:26 GMTib.naji