Provides detailed statistics about processes that are currently executing or waiting. monProcess requires the enable monitoring and wait event timing configuration parameters to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
KPID |
int |
Kernel process identifier |
|
FamilyID |
smallint |
The SPID of the parent process, if it exists |
|
BatchID |
int |
Unique identifier for the SQL batch containing the statement being executed |
|
ContextID |
int |
The stack frame of the procedure, if it exists |
|
LineNumber |
int |
Line number of the current statement within the SQL batch |
|
SecondsConnected |
int |
Number of seconds since this connection was established |
|
WaitEventID |
smallint |
Unique identifier for the event that the process is waiting for, if the process is currently in a wait state |
|
BlockingSPID |
smallint |
Session process identifier of the process holding the lock that this process has requested, if waiting for a lock |
|
DBID |
int |
Unique identifier for the database being used by the current process |
|
EngineNumber |
int |
Unique identifier of the engine on which the process is executing |
|
Priority |
int |
Priority at which the process is executing |
|
Login |
varchar(30) |
null |
Login user name |
Application |
varchar(30) |
null |
Application name |
Command |
varchar(30) |
null |
Category of process or command that 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 that the process has been waiting, if the process is currently in a wait state |
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 process for the database being used by the current process |
EngineGroupName |
varchar(30) |
null |
Engine group for the process |
ExecutionClass |
varchar(30) |
null |
Execution class for the process |
MasterTransactionID |
varchar(255) |
null |
Unique transaction identifier for the current transaction, if in a transaction |
