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

  • December 21, 2017 at 9:20 am

    #1973110

    shahgols - Thursday, December 21, 2017 8:59 AM

    Hi Sue, I have done a SUM on pages_kb in dm_os_memory_clerks, which adds up the space taken by all clerk types.  The total is 22GB.  SQL Server is using 51GB, and PLE is 51, so that's why I am wondering where the rest of the RAM has gone.

    Hi Subramanian, do you have any scripts, there is a lot of information in those tables and I am not sure what I am looking for.

    There are over 20 different queries in the link I provided that will walk you through your memory usage - it would likely be good to read the article and work through the scripts. They are all memory specific - the link is: 
    Troubleshooting SQL Server Memory

    In addition to the memory clerks, his advise is to also use the following - refer to the article for more information:
    select * from sys.dm_os_memory_objects
    select * from sys.dm_os_memory_pools
    select * from sys.dm_os_memory_nodes
    select * from sys.dm_os_memory_cache_entries
    select * from sys.dm_os_memory_cache_hash_tables

    Sue