April 16, 2013
by
0 comments | 7,390 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

March 27, 2013
by
0 comments | 12,777 views

VN:RO [1.9.17_1161]

Long-running job

This metric returns the longest running instance of the named job in the last hour. By creating multiple custom metrics from this example – one for each job you’re interested in – you can specify alert thresholds for each job individually. Read more

February 27, 2013
by
0 comments | 4,365 views

VN:RO [1.9.17_1161]

Database growth steps available

This metric measures the number of available autogrowth steps for a database, so you can see when they are reduced or increased because something else (e.g. another database) starts or stops taking up space, when storage is added, etc. Read more

February 13, 2013
by
1 Comment | 8,278 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