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

  • December 20, 2017 at 8:47 pm

    #1973033

    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!

    Hi,
    Okay, Can you try these DMVs against your database / data warehouse ?
    sys.dm_exec_connections
    sys.dm_exec_sessions
    sys.dm_exec_requests
    sys.dm_exec_sql_text
    sys.sysprocesses
    OR you can even use SP_WHO, SP_WHO2
    these could give an idea where are the bottlenecks in your database / against your RAM.
    If the all above does not resolve the issues, You can check for the existing blockings in RAM and try to clean the procache.