Category Archives: MSSQLServer

Status in SP_WHO2 command in MS SQL Server

Meaning of Status Column in SP_WHO2 command in MS SQL Server

Excuteh the sp_who2 command:

Status column has different values and following are the meaning of values:

STATUS Column:
Background: The process is for a background task i.e. RECOVERY WRITER, LAZY WRITER & LOCK MONITOR
Sleeping: The process is waiting for a command from the application.
Running: The process is currently running on a scheduler.
Runnable: The process is in the queue of a scheduler and waiting to get executed.
Suspended:
The process is waiting for a resource i.e a lock or a latch.