February 13, 2013
by
1 Comment | 4,464 views

VN:RO [1.9.17_1161]

Low physical/external memory

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

January 15, 2013
by
2 Comments | 3,095 views

VN:RO [1.9.17_1161]

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

July 4, 2012
by
0 comments | 6,127 views

VN:RO [1.9.17_1161]

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

July 4, 2012
by
4 Comments | 5,503 views

VN:RO [1.9.17_1161]

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