Average runnable task count

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
10,790 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: 4.7/5 (3 votes cast)
3
20,038 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
25,442 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.2/5 (13 votes cast)
13
52,820 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
6,306 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
20,966 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

Top buffer cache object

VN:RO [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
0
13,133 0 ,
This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. Read more