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