monWaitEventInfo

Description

Provides a textual description of wait conditions reported in the monSysWaits and monProcessWaits tables.

You need not enable any configuration parameters for this monitoring table to collect data.

Columns

The columns for monWaitEventInfo are:

Name

Datatype

Attributes

Description

WaitEventID

smallint

Unique identifier for the wait event type

WaitClassID

smallint

Unique identifier for the wait event class

Description

varchar(50)

Null

Description of the wait event type

Language

varchar(30)

Allows you to specify the language in which Adaptive Server returns the values of the Description column.

By default, Adaptive Server returns US English. Queries must use the the IS0-639 and ISO-3166 naming conventions.

Join monWaitEventInfo with monProcessWaits or monSysWaits on the WaitEventID column to obtain the wait event descriptions listed in those tables.