Post reply

After I killed the SPID. it went on Killed/Rollback state and physical IO is also not moving

  • January 30, 2012 at 10:56 am

    #252125

    After I killed the SPID. it went on Killed/Rollback state and physical IO is also not moving pls advice

    Thanks in advance

  • January 30, 2012 at 11:00 am

    #1440159

    the spid went in rollback state it will take time to rollback.

    Execute Kill Spid with Statusonly and see till what % that has been completion.

    More Information:

    http://msdn.microsoft.com/en-us/library/ms173730.aspx

  • January 30, 2012 at 11:09 am

    #1440162

    Wait until the rollback is complete.

    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