Overview
The TimeLine Wait Event Monitoring Option extends the TimeLine performance monitor to provide information on wait events incurred by database processes and by the database server as a whole.
Features
The TimeLine Wait Event Monitoring Option gathers and presents wait event data in several ways:
- It shows wait information per user process in the database server, as part of database process snapshots;
- It displays server-wide wait event statistics in a pie chart and graphed over time;
- It provides the TimeLine Top-N Wait Event Report, which reports the wait events that incurred the most total wait time during a selected reporting period;
- When used in conjunction with the TimeLine Reporting Option, it adds options to the various TimeLine Top-N reports to group by process wait time and wait count.
When you enable gathering of wait event data in database snapshots, TimeLine displays a list of recent events for a process you have selected (for SQL Server, it displays the process’s current wait event).
Like the other information in TimeLine, the wait event data is synchronized to the selected point in time, so you can step through events and see what wait events were incurred over time.
Enabling wait event gathering also allows you to report on process wait events over a longer period of time. For example, you can report on the Top-N applications or users whose SQL incurred wait time due to disk I/O or network I/O, or you can view the Top-N SQL statements with the most wait time due to blocking.
Database Support
The TimeLine Wait Event Monitoring Option supports SAP Sybase ASE 12.5.0.3 through 16.0, and Microsoft SQL Server 2005 through 2022.