Taken from the books online reference for sys.processes and the status column. dormant = SQL Server is resetting the session. running = The session is running one or more batches. When Multiple Active Result Sets (MARS) is enabled, a session can run multiple batches. For more information, see Using Multiple Active Result Sets (MARS). background = The session is running a background task, such as deadlock detection. rollback = The session has a transaction rollback in process. pending = The session is waiting for a worker thread to become available. runnable = The task in the session is in the runnable queue of a scheduler while waiting to get a time quantum. spinloop = The task in the session is waiting for a spinlock to become free. suspended = The session is waiting for an event, such as I/O, to complete.
Hello there I am so happy I found your site, I really found you by
BalasHapuserror, while I was researching on Digg for something else, Anyhow I am here now and would just like to say thanks a lot for a tremendous post
and a all round thrilling blog (I also love the theme/design), I don’t have time to browse it all at the minute but I have bookmarked it and also added in your RSS
feeds, so when I have time I will be back to read a lot more, Please do keep up the fantastic b.