What are SQL wait events?
Wait events are characteristic parts of the Oracle kernel source code that can contain Oracle sessions during execution. Oracle provides statistical information on the wait events, which comprises the following components:
- Name of the wait event
- Optional: Up to three parameters of different importance depending on the wait event.
How to perform a wait event analysis for SQL Server?
Run program /SDF/RSMSSVSE.
The wait event analysis available with this Add-On is described below structured in sections functionality, usage, and known issues.
- Functionality- Wait Event Analysis For SQL Server
- Usage- Wait Event Analysis For SQL Server
- known issues- Wait Event Analysis For SQL Server