Provides a list of all wait events for which current processes on the server are waiting. Returns only wait events whose Waits value is greater than zero.
Enable the enable monitoring, process
wait events, and wait event timing configuration
parameters for this monitoring table to collect data.
Name |
Datatype |
Attribute |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
KPID |
int |
Kernel process identifier |
|
WaitEventID |
smallint |
Unique identifier for the wait event |
|
Waits |
int |
Counter |
Number of times the process has waited for the event |
WaitTime |
int |
Counter |
Amount of time, in milliseconds, that the process has waited for the event |
WaitEventInfo contains descriptions of each wait event. Join the WaitEventID column from each monitor table to view this data.
See Chapter 3, “Wait Events,” for a descriptions of select wait events.
