June 5, 2013
by
0 comments | 5,884 views

VN:RO [1.9.17_1161]

Percentage of blocked connections

Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention. Read more

March 27, 2013
by
0 comments | 6,814 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

November 8, 2012
by
0 comments | 3,886 views

VN:RO [1.9.17_1161]

Plan cache hit ratio

A high plan cache hit ratio does not guarantee that all queries are using the cache as well as they might. Knowing the percentage of queries that are satisfied from cache helps you to better understand the plan cache hit ratio value. Read more