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