SQL Server Performance Forum – Threads Archive
transaction rollback in progressHi, 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]
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…