Top SQL Statements by Memory Usage
The metrics in this category provide information regarding the SQL statements that have been using the most memory.
Collection Frequency - Every 30 minutes
Table 4-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. |