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. |