Transaction Statistics Summary with SQL List
Use this page to review information about the recent transactions that were run on the database server.
Prerequisite: SQL
tracing must be on to collect the information that is displayed on
this page. On the page, set the Trace State option
to On.
- Transaction Statistics Summary
- This section displays detailed statistics about the selected transaction.
- SQL List
- This list contains the following information for each SQL statement. To view more details, click the drill-down icon.
- SQL ID
- The assigned identifier for the SQL statement.
- Response Time
- The length of time required to run the SQL statement, in seconds.
- Rows/Second
- The average number of rows processed per second by the SQL statement.
- Rows Processed
- The number of rows processed by the SQL statement.
- Lock Wait Time
- The time spent waiting for locks to be removed while the SQL statement was running, in seconds.
- Wait I/O Time
- The average amount of time spent waiting for I/O while the SQL statement was running, in seconds.
- SQL Statement
- The text of the SQL statement that was selected for query drill-down.