OS Wait Time: CXPACKET

VN:RO [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
1
4,558 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 (2 votes cast)
2
9,036 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
3,145 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
5,313 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 (1 vote cast)
1
9,450 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

Percentage of fragmented indexes

VN:RO [1.9.17_1161]
Rating: 5.0/5 (3 votes cast)
3
17,326 0 ,
This is a general indicator of performance problems. Index fragmentation can affect the rate of return for moderate to large tables. If multiple indexes are fragmented throughout the database, then an index maintenance strategy needs to be evaluated. Read more

Average I/O stalls

VN:RO [1.9.17_1161]
Rating: 4.3/5 (11 votes cast)
11
30,488 0 ,
This is a general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client. Read more

Number of ascending statistics

VN:RO [1.9.17_1161]
Rating: 4.0/5 (1 vote cast)
1
4,205 0
This metric returns the number of ascending statistics per database. A common problem relating to distribution statistics is associated with “ascending value columns” in a table. Read more

Tempdb allocation contention

VN:RO [1.9.17_1161]
Rating: 3.6/5 (5 votes cast)
5
13,917 0
If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Read more