1.64 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 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.