Hello,
I'm running Sql server 2005 and I've noticed that when I kill a
process, it always shows
"Estimated rollback completion: 0%. Estimated time remaining: 0
seconds."
Even though the process does kill successfully, these numbers never
change. Is there some setting I have to change or what?
I'm running :
kill spid
This result always shows 0% completion. Whether it takes 5 seconds or 8 hours to rollback, I always see 0% completion. (I had a process today that I had to kill
after running for 6 hours and it took 8 hours to kill but I had no idea
about it's progress.)
In sql 2000, this worked everytime I killed a process. I could see the
% changing and the estimated time to complete changing.
Any ideas?
ClemThis post looks familiar...
If you have a large transaction that needs rolling back, it could take a long time.
This KB is a very good reference for the "kill" process. I suggest you take a quick peek.
http://support.microsoft.com/kb/171224sql
No comments:
Post a Comment