Home Forums SQL Server 2008 SQL Server 2008 Administration Can't Kill SPID “Transaction Rollback in Progress” RE: Can't Kill SPID “Transaction Rollback in Progress”

  • February 26, 2013 at 9:00 pm

    #1591371

    There are no easy methods to kill the damned things. The 0% rollback is actually a documented problem and, IIRC, has an open/active CONNECT item against it.

    There are two types of 0% rollbacks... those that are benign and those that eat the processing time of nearly a full CPU. You can just ignore the ones that are NOT using CPU time. Tthe ones that are using scads of CPU are obviously a problem and, as of right now, the only ways to remove them is to either bounce the service or bounce the server.

    As a side bar, I try not to kill spids. I send the user an email. Then I find out where they sit and pay them a personal visit to try show them what they're doing wrong. I might even help them with their code. Most of the folks are absolutely grateful.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)