The metrics in this category provide information regarding the SQL statements that have been using the most memory.
Collection Frequency - Every 30 minutes
Table 3-48 Top SQL Statements by Memory Usage
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. |
Average Memory Usage (KB) |
The amount of memory used by the SQL statement. |