Activity Summary

Use this page to review information about the SQL statements that were run on the current database server, by type.

Prerequisite: SQL tracing must be on to collect the information that is displayed on this page. On the Performance Analysis > SQL Explorer > Tracing Admin page, set the Trace State option to On.

SQL Statement Summary

This table displays information about the SQL statements captured by SQL tracing. To view more details, click the drill-down icon for a statement type. You can then drill down on the statements of that type.

Statement Type: The SQL statement type; for example, SELECT, INSERT, or EXEC PROCEDURE.
Count: The number of times that the statements were run.
Avg Response Time: The average elapsed run time for the statements, in seconds.
Max Response Time: The longest run time among the statements, in seconds.
Avg Memory: The average memory usage for the statements.
Rows Processed: The number of rows processed by the statements.

Transaction Summary

This table displays the following information about the transactions captured by SQL tracing. Click the drill-down icon to see more details. You can then drill down on the transactions.

Type: Transaction.
Count: The number of transactions.
Avg SQL Stmts: The average number of SQL statements per transaction.
Avg Response Time: The average elapsed run time for the transactions, in seconds.
Max Response Time: The longest run time among the transactions, in seconds.
Avg Memory: The average memory usage for the transactions.
Avg Rows: The average number of rows processed per transaction.
Total Rows: The total number of rows processed in the transactions.