Views for transaction delay analysis
The views to manage transaction elapsed time are organized into the following groups:
- Transaction-delay-views
- Database-I-O-delay-views
- Data-set-I-O-delay-views
- Volume-I-O-delay-views
- Lock-delay-views
- Latch-delay-views
To analyze transaction delays, start with the IDLTR view, which shows all transactions and the delays that contributed to each transaction’s elapsed time. If a transaction shows an unusual elapsed time, you can hyperlink from its transaction code field to access a menu that you can use to access additional transaction delay information.
The information displayed in the delay views correlates event and sample data. The accuracy of the statistical analysis depends on the number of observations made. In each of the views, a Confidence Level column is included to reflect the accuracy of the analysis. If information shows a confidence level of None, do not spend time analyzing the information.
Related topic