The metrics in this category provide details about the top queries by total blocked time.
Evaluation and Collection Frequency — Every 1 Hour
Table 1-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. |