Top Queries by Total Blocked Time
The metrics in this category provide details about the top queries by total blocked time.
Evaluation and Collection Frequency — Every 1 Hour
Table 2-75 Top Queries by Total Blocked Time Metrics
| Metric | Description |
|---|---|
|
Query Hash (key) |
An MD5 hash of the query text. |
|
Query |
Text of the query. |
|
Total Blocked Time (ms) |
Total amount of time the query has spent waiting for the CPU since the SQL Server service started. |
|
Blocked Time (ms) per Hour |
Amount of time the query spent waiting for the CPU per hour during the previous collection interval. |