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