SQL Server Performance Forum – Threads Archive

transaction rollback in progress

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

---

Its status is ‘SUSPENDED’. Ashish Johri

---

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

---

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

---

]]>