Post reply

Move sleeping spid to running or RUNNABLE

  • November 30, 2015 at 11:07 pm

    #399407

    Hi,

    Can we move sleeping spid to running or RUNNABLE manually or by user command?

    thanks

  • December 1, 2015 at 12:54 am

    #1843089

    To my knowledge there is no way to do this as there are simply connections that are open but not in use.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

  • December 1, 2015 at 1:47 am

    #1843100

    Sleeping means it has no work to do, there's no commands being run on that connection. So if can't go to running, it has nothing to run.

    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 3 posts - 1 through 2 (of 2 total)

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