LLI Wiki — My Digital Knowledge Base

SQL Server session and request status values

Meaning of the Dormant, Running, Runnable, Suspended, Pending and other status values in the session and request views.

SQL Server reports a status for each session and for each request that it runs. The table below lists the status values with their meaning, as described in the Microsoft reference.

Status Meaning
Dormant SQL Server is resetting the session.
Running The session is running one or more batches. With Multiple Active Result Sets (MARS) enabled, a session can run several batches.
Background The session runs a background task, such as deadlock detection.
Rollback The session is rolling back a transaction.
Pending The session waits for a worker thread to become available.
Runnable The task is in the runnable queue of a scheduler and waits for a time slice.
Spinloop The task waits for a spinlock to become free.
Suspended The session waits for an event, such as an I/O operation, to complete.

Notes

Mastodon LLIMastodon SocialFosstodon