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
    georgej, Jul 17, 2007
    #2

  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.
    MohammedU, Jul 17, 2007
    #2

  3. Mario Luna New Member

    Hi, MohammedU
    Dou you have any documentation about this issue ???
    Thanks.
    Mario
    Mario Luna, Feb 16, 2009
    #3

  4. Kewin New Member

    Kewin, Feb 19, 2009
    #4

  5. satya Moderator

    Do you see any errors or warnings on the server for CPU & disks/
    satya, Feb 19, 2009
    #5

Share This Page