January 26, 2014 at 6:16 pm
Transaction has been killed and is in a very long rollback. Processes are being blocked. What do you do?
January 27, 2014 at 12:09 am
Wait. Because there's nothing else you can do.
Search the forums on this site for several cases where people have been in that situation and see what some of them have done to make matters worse.
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
January 27, 2014 at 12:11 am
Mani-584606 (1/26/2014)
Transaction has been killed and is in a very long rollback. Processes are being blocked. What do you do?
Split up transactions in smaller chunks so that you don't have to wait that long when a transaction needs to roll back.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply