Home Forums SQL Server 2012 SQL 2012 - General What is using the RAM? RE: What is using the RAM?

  • December 20, 2017 at 5:01 pm

    #1973020

    shahgols - Tuesday, December 19, 2017 2:51 PM

    Hi everyone, I've been investigating RAM bottleneck on one of my servers, and it looks like the buffer pool is only using 23GB out of 51GB for buffer pool, but I am unable to find out what is using the remaining 28GB of RAM.  I've run some queries and am attaching the results for your consideration.  This server has SQL 2012 Enterprise (SP3) on Windows 2012 Standard.  Thanks in advance!

    When you query sys.dm_os_memory_clerks, look at the other memory clerk types - the ones that are not MEMORYCLERK_SQLBUFFERPOOL.
    I don't know of a list of all of the different types -  usually just search on the types.
    You can find some additional queries for troubleshooting memory issues in this post:
    Troubleshooting SQL Server Memory

    Sue