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