Transactions
The Transactions dashboard lists all the current transactions and provides additional information, including transaction time, contention, and retries, which help identify slow transactions. The following screenshot is of a Transactions dashboard showing transaction details:
Figure 8.12 – Transactions dashboard showing transaction details
The Transaction dashboard shows the following details:
- Transactions: SQL statements that are part of the transaction
- Execution Count: Total number of executions for a given transaction
- Rows Read: Average number of rows read from disk during the transaction
- Bytes Read: Total number of bytes read across all the statements in a transaction
- Transaction Time: Average planning and execution time
- Contention: Average time a given transaction was in contention with other transactions
- Max Memory: Maximum memory used by a given transaction
- Network: Amount of data transferred...
