Home Forums SQL Server 2008 SQL Server Newbies Understanding Memory Clerks RE: Understanding Memory Clerks

  • November 7, 2012 at 12:10 pm

    #1556894

    George M Parker (11/7/2012)

    Check out the following: http://www.sqlservercentral.com/Forums/Topic1340744-391-1.aspx

    If you order by Virtual_memory_committed_kb, you should see MEMORYCLERK_SQLBUFFERPOOL as the largest consumer of memory.

    select * FROM sys.dm_os_memory_clerks

    order by Virtual_memory_committed_kb desc

    I'm still trying to find a definitive reference that adequately defines sys.dm_os_memory_clerks and what all of the columns mean.

    Thanks for this

    Do you know of a way to check if my an instance is experiecing a plan cache bloat? What I mean is, how can I check what the allocated size of my plan cache is and how much of it has been used.

    Thanks