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

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.