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