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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.