monSysWaits

Description

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.

Columns

Name	Datatype	Attributes	Description
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 Chapter 3, “Wait Events,” 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