Views for transaction delay analysis
The views you use to manage transaction response time are organized in the following delay groups:
- Transaction-delay-views-IDLTR
- Database-I-O-delay-views
- Data-set-I-O-delay-views-IDLDD
- Volume-I-O-delay-views
- Lock-delay-views-IDLLK
- Latch-delay-views-IDLLH
To analyze transaction delays, start with the IDLTR view, which shows all transactions and the delays that contributed to each transaction’s response time. If a transaction shows an unusual response 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