SQL Server Performance

Activity Monitor Statuses - Sleeping and Suspended

Discussion in 'SQL Server 2005 General DBA Questions' started by jbates99, Jun 22, 2009.

  1. jbates99 Member

    hi all,

    When does a SPID status change to 'Sleeping' and what does that indicate? I'm assuming that after so many seconds or minutes have passed with no activity, it changes the status to Sleeping - is that correct? What is the length of time?


    And what does 'Suspended' mean? Will a Blocked process eventually show 'Suspended'?

    Thanks,
    John
  2. sleeping - The process has work to perform, but is waiting for something, such as a lock or user input. suspended -
    Suspended - The process has work to perform but has been stopped. The status field does not contain the reason the process was suspended. The Wait Type field may contain information about why the process is suspended.

Share This Page