Provides detailed statistics about processes that are currently executing or waiting.
Enable the enable monitoring and wait event timing configuration parameters for this monitoring table to collect data.
The columns for monProcess are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier |
|
ServerUserID |
int |
Server user ID (SUID) of the user associated with this process. |
|
BatchID |
int |
Unique identifier for the SQL batch containing the executing statement |
|
ContextID |
int |
A unique identifier generated each time an executing query causes a stored procedure, trigger, execute immediate, deferred compilation, or other compiled object execution to occur |
|
LineNumber |
int |
Line number of the current statement within the SQL batch |
|
SecondsConnected |
int |
Number of seconds since this connection was established |
|
DBID |
int |
Unique identifier for the database used by the process |
|
EngineNumber |
smallint |
Unique identifier of the engine on which the process is executing |
|
Priority |
int |
Priority at which the process is executing |
|
FamilyID |
int |
Null |
spid of the parent process, if this is a worker process |
Login |
varchar(30) |
Null |
Login user name |
Application |
varchar(30) |
Null |
Application name. May be blank if the application did not set a name in its login structure. |
Command |
varchar(30) |
Null |
Category of process or command the process is currently executing |
NumChildren |
int |
Null |
Number of child processes, if executing a parallel query |
SecondsWaiting |
int |
Null |
Amount of time, in seconds, the process has been waiting, if the process is currently blocked by a lock held by another process. |
WaitEventID |
int |
Null |
Unique identifier for the event for which the process is waiting, if the process is currently in a wait state. |
BlockingSPID |
int |
Null |
Session process identifier of the process holding the lock this process requested, if waiting for a lock |
BlockingXLOID |
int |
Null |
Unique lock identifier for the lock that this process has requested, if waiting for a lock |
DBName |
varchar(30) |
Null |
Name of the database the process is currently using |
EngineGroupName |
varchar(30) |
Null |
Engine group for the process |
ExecutionClass |
varchar(30) |
Null |
Execution class for the process |
MasterTransactionID |
varchar(255) |
Null |
Name of the transaction the process has open |
HostName |
varchar(30) |
Null |
Name of the host machine on which the application that started the process is running. |
ClientName |
varchar(30) |
Null |
Value of the clientname property set by the application. |
ClientHostName |
varchar(30) |
Null |
Value of the clienthostname property set by the application. |
ClientApplName |
varchar(30) |
Null |
Value of the clientapplname property set by the application. |
