SQL Server Performance

What does Status=SUSPENDED mean?

Discussion in 'SQL Server 2005 General DBA Questions' started by georgej, Jul 17, 2007.

  1. georgej New Member

    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
  2. MohammedU New Member

    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.
  3. Mario Luna New Member

    Hi, MohammedU
    Dou you have any documentation about this issue ???
    Thanks.
    Mario
  4. Kewin New Member

  5. satya Moderator

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

Share This Page