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