What does Status=SUSPENDED mean? | SQL Server Performance Forums
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!
From BOL… suspended: The session is waiting for an event, such as I/O, to complete. MohammedU.
Microsoft SQL Server MVP
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Dou you have any documentation about this issue ???
BOL (aka Books On Line) which documents this, can be found here:
Do you see any errors or warnings on the server for CPU & disks/