Top SQL Statements by Wait Time

The metrics in this category provide information regarding the SQL statements that have been spending the most time waiting.

Collection Frequency - Every 30 minutes

Table 4-47 Top SQL Statements by Wait Time Metrics

Metric	Description
SQL Hash	An MD5 hash of the statement text.
SQL Text	The statement text that executed.
Database ID	The ID of the database in which the statement executed.
Database Name	The name of the database in which the statement executed.
Last Start Time	The last time the statement started executing.
Wait Time (ms) per Hour	The amount of time the statement has spent executing, as an hourly rate.