monSysWaits

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.

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

Columns

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