SQL Server Performance

transaction rollback in progress

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by ashish.johri2007, Mar 15, 2007.

  1. ashish.johri2007 New Member

    Hi, I have killed that one SP today morning. The status is still ‘KILLED/ROLLBACK#%92. How can I get rid of this.


    When I use kill command like thi…

    kill 73 this shows gives an error:

    SPID 73: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

    DB is hanged. HOw can I get rid of this immediately?

    Pls help.[V]


    Ashish Johri
  2. ashish.johri2007 New Member

    Its status is 'SUSPENDED'.

    Ashish Johri
  3. madhuottapalam New Member

    if the killed transaction is a large transaction rolling back will take time and it is a normal behaviour because the database should be in consistant stage when the process is killed.

    check out this :http://support.microsoft.com/kb/171224

    Madhu
  4. MohammedU New Member

    If you run again KILL command with same SPID you will see roll backup time left and roll back percentage... but some times but not always this value may be incorrect...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page