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.