The metrics in this category provide detailed statistics about processes that are currently executing or waiting.
Collection frequency - Every 30 minutes
Table 3-38 Process Statistics Metrics
Metric | Description |
---|---|
Application Name |
Application name. |
Blocking SPID |
Session process identifier of the process holding the lock that this process has requested, if waiting for a lock. |
Requested Lock ID |
Unique lock identifier for the lock that this process has requested, if waiting for a lock. |
Command |
Category of process or command that the process is currently executing. |
DBID |
Unique identifier for the database being used by the current process. |
DB Name |
Name of process for the database being used by the current process. |
Process Engine Group Name |
Engine group for the process. |
Engine Number |
Unique identifier of the engine on which the process is executing. |
Process Execution Class |
Execution class for the process. |
FID |
The SPID of the parent process, if it exists. |
Statement position in SQL batch |
Line number of the current statement within the SQL batch. |
Login Name |
Login user name. |
Master Transaction ID |
Unique transaction identifier for the current transaction, if in a transaction. |
Number of child processes |
Number of child processes, if executing a parallel query. |
Process Priority |
Priority at which the process is executing. |
Elapsed time since connection established (seconds) |
Number of seconds since this connection was established. |
Process waiting time (seconds) |
Amount of time in seconds that the process has been waiting, if the process is currently in a wait state. |
Wait Event ID |
Unique identifier for the event that the process is waiting for, if the process is currently in a wait state. |
KPID |
Kernel process identifier. |
Procedure stack frame |
Stack frame of the procedure. |
SPID |
Session process identifier. |
SQL Batch ID |
SQL batch identifier. |