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, wait event timing, and process wait events, configuration parameters for this monitoring table to collect data.
The columns for monProcessWaits are:
Name |
Datatype |
Attribute |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier |
|
ServerUserID |
int |
Server user ID (SUID) of the user associated with this process. |
|
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 Performance and Tuning: Monitoring Tables for a descriptions of select wait events.
