Top SQL Statements by CPU Time
The metrics in this category provide information regarding the SQL statements that have been using the most CPU time.
Collection Frequency - Every 30 minutes
Table 4-46 Top SQL Statements by CPU 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. |
CPU Time (ms) per Hour |
The amount of time the statement has spent executing as an hourly rate. |