Category: Performance

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

This metric counts how many queries are running, and alerts you if the value goes above a defined threshold. Read more

This metric measures the total number of indexes per database, where the number of writes exceed the number of reads. It provides a general indicator of possible performance factors affecting queries in your database. Read more

This metric tells you whether a database is online, restoring, recovering, recovery pending, suspect, emergency, offline or does not exist on the server. Read more

CXPACKET waits may or may not be an issue for a system, but on an OLTP style system, they can indicate costly queries that are executing and requiring parallelized plans. Read more

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

This metric shows the percentage of cached plans that are being used more than once. If a plan is cached but never reused, there may be an opportunity to tune your server to work more effectively. Read more

This metric gives an idea of how many task are in a runnable state and trying to execute in the system concurrently. Read more