monProcessWaits

Description

Provides a server-wide view of where processes are waiting for an event. monProcessWaits requires the enable monitoring and process wait events configuration parameters to be enabled.

Columns

Name

Datatype

Attribute

Description

SPID

smallint

Session process identifier

KPID

int

Kernel process identifier

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