What does the status column of a session mean in SQL Server?

You might notice there is a status column when you look at active executing requests in either sys.dm_exec_requests, sys.dm_exec_sessions, or sysprocesses.  The status column indicates a general status of what the session is doing. background Usually these sessions aren’t a concern.  Not much interesting happening as they are typically housekeeping tasks. rollback You’ll see this […]

Read More

Negative blocking session ids

On occasion while examining lock scenarios, I’ve seen a lead blocker with a negative session ID.  After looking in the documentation for the blocking_session_id, it explained why I am seeing this (taken directly from Microsoft’s sys.dm_exec_requests documentation): -2 = The blocking resource is owned by an orphaned distributed transaction. -3 = The blocking resource is […]

Read More