SQL Server Performance Forum – Threads Archive

What does Status=SUSPENDED mean?

I run sp_who2 to check SQL server 2005 activities.
I find some SPID with Status=SUSPENDED.
What does this mean? Thanks for help!
George

From BOL… suspended: The session is waiting for an event, such as I/O, to complete. MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hi, MohammedU
Dou you have any documentation about this issue ???
Thanks.
Mario

BOL (aka Books On Line) which documents this, can be found here:
http://msdn.microsoft.com/en-us/library/ms130214.aspx
/Kenneth

Do you see any errors or warnings on the server for CPU & disks/

]]>