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
DormantandRunningare session states (sys.dm_exec_sessions). The other values are request states (sys.dm_exec_requests). The table above follows the source note and does not separate them.- For the current list of values, see the Microsoft references sys.dm_exec_sessions and sys.dm_exec_requests.