Home Forums SQL Server 2008 SQL Server Newbies Does Resource Monitor report SQL Server memory usage correctly RE: Does Resource Monitor report SQL Server memory usage correctly

  • Arsh - Thursday, November 9, 2017 6:49 AM

    I suppose querying SQL itself will be best to get accurate values .  Why do you suspect Resource Monitor ?
    Can use this script to get buffer pool usage directly from SQL server :

    Buffer pool usage would not be more accurate as it is only part of SQL Server's memory usage.
    There are numerous things consuming memory outside of the buffer pool. Some of this is explained in the documentation for memory server configurations - which also explains why it is not unusual to see SQL Server consuming more than the max memory settings:
    Server Memory Server Configuration Options
    max server memory controls the SQL Server memory allocation, including the buffer pool, compile memory, all caches, qe memory grants, lock manager memory, and clr memory (essentially any memory clerk found in sys.dm_os_memory_clerks). Memory for thread stacks, memory heaps, linked server providers other than SQL Server, and any memory allocated by a non SQL Server DLL are not controlled by max server memory.

    Sue