Recent Transactions

Use this page to review information about the recent transactions that were run on the database server, by transaction time.

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.

The list contains the following information for each transaction. To view more details about a transaction, click the drill-down icon.

Transaction Stamp: An identifier for the transaction running at the current server.
Session ID: The database session ID of the user running the SQL statement.
Count: The number of SQL statements in the transaction.
Average Response Time: The average amount of time the transaction took to complete.
Maximum Response Time: The largest amount of time the transaction took to complete.
Average Memory: The average amount of memory used to complete the transaction.
Rows Processed: The number of rows processed for the transaction.