Provides detailed statistics about processes that are currently executing or waiting.
Enable the enable monitoring configuration parameter 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. |