Provides a server-wide view of the statistics for events on which processes have waited.
Enable the enable monitoring and wait event timing configuration parameters for this monitoring table to collect data.
The columns for monSysWaits are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
WaitEventID |
smallint |
Unique identifier for the wait event |
|
WaitTime |
int |
Counter |
Amount of time (in seconds) tasks spent waiting for the event |
Waits |
int |
Number of times tasks waited for the event |
See Performance and Tuning: Monitoring Tables for more information
You can join the monSysWaits table with monWaitEventInfo using the WaitEventID columns as the join column to obtain the wait event descriptions. For example:
select w.Waits, w.WaitTime, w.WaitEventID, i.Description from master..monSysWaits w, master..monWaitEventInfo i where w.WaitEventID = i.WaitEventID