Long-running job

VN:RO [1.9.17_1161]
Rating: 3.8/5 (8 votes cast)
8
15,828 1
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

Number of queries running

VN:RO [1.9.17_1161]
Rating: 4.2/5 (6 votes cast)
6
6,384 0
This metric counts how many queries are running, and alerts you if the value goes above a defined threshold. Read more

Indexes with excessive writes

VN:RO [1.9.17_1161]
Rating: 3.9/5 (7 votes cast)
7
13,670 0
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

Database state

VN:RO [1.9.17_1161]
Rating: 3.0/5 (2 votes cast)
2
5,682 0
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

Cached pages in TempDB (MB)

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
7,010 0 ,
This metric helps a DBA analyze how well TempDB is working on their server. Knowing more about what is stored in it, and by which process, will greatly help diagnose performance issues. Read more

OS Wait Time: CXPACKET

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
5,595 0
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

Plan cache hit ratio

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
12,008 0
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

Plan cache reuse

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
4,134 0
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

Average runnable task count

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
6,802 0
This metric gives an idea of how many task are in a runnable state and trying to execute in the system concurrently. Read more

CPU signal wait time

VN:RO [1.9.17_1161]
Rating: 5.0/5 (2 votes cast)
2
12,273 0
This metric measures the percentage of time spent waiting for CPU resources to service a thread. A high signal wait time for all wait types may indicate that CPUs are being overused, forcing tasks to wait for SQL Server processes. Read more