Determining if your operating system is causing memory issues within your SQL Server instance can be a challenge. One way around it is to use the sys.dm_os_ring_buffers to show when server memory is low. Read more
Category: Memory
Low virtual memory
Determining if your SQL Server instance is experiencing memory issues within the SQL Server Virtual Address Space (VAS) can be a challenge. One way around it is to use the sys.dm_os_ring_buffers. Read more
Top buffer cache object
This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. Read more
Sort warnings (last hour)
This example custom metric measures the number of sort warnings events per hour. Read more
Hash warnings (last hour)
This metric measures the number of hash warnings events in the last hour. A hash warning event means that part of the data processed for a hash operation was written to tempdb. Read more
Out of memory errors
The number of out of memory errors that have occurred within a rolling five minute window. If you just want to keep an eye out for any memory errors, you can watch the ring buffers for the Out of Memory error alert when it gets registered there. Read more
Buffer pressure
Trying to determine if you have pressure in your buffer allocations can be difficult. Buffer cache hit ratio is an almost useless metric, so you need a mechanism to let you know if there’s a problem in that area. Read more
SQL Server: Plan cache: cache pages total
This metric counts the number of 8-kilobyte (KB) pages used by plan cache objects, which indicates the plan cache size of an instance. Read more
SQL Server: memory manager: optimizer memory (KB)
This metric measures the total amount of dynamic memory (in kilobytes) on the server being used for query optimization. Read more
SQL Server: memory manager: SQL cache memory
This metric specifies the total amount of dynamic memory, in kilobytes (KB) the server is using for the dynamic SQL plan cache. Read more