Post reply

Sleeping and suspended processes

  • May 12, 2011 at 9:41 am

    #240319

    Hello all,

    What is the difference between sleeping and suspended processes, if both are waiting for resources to be freed?

    Thanks.

  • May 12, 2011 at 9:59 am

    #1323785

    They're not both waiting for resources.

    A sleeping process is one that is doing nothing. It's finished running any queries and is just sitting idle. If you connect from management studio, run a query and then don't close the window, that connection will be sleeping.

    A suspended process is waiting for some resource before it can finish running the query. Check the wait type for what it's waiting for and the wait time for how long its been waiting.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 12, 2011 at 10:10 am

    #1323797

    Thanks for your reply. So if a process is suspended, shouldn't there be something in blocked by column?

  • May 12, 2011 at 10:24 am

    #1323808

    Not necessarily. Locks are just one of the many things it could be waiting for.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply