April 16, 2013
by
0 comments | 6,540 views

VN:RO [1.9.17_1161]

Status of the witness

This metric returns a single value that tells you whether the witness is connected, disconnected or unknown. Knowing if it is offline can be as important as knowing if your mirrored databases are available. Read more

February 13, 2013
by
1 Comment | 7,758 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 | 5,677 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 | 8,323 views

VN:RO [1.9.17_1161]

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