Friday, March 23, 2012

kill process always shows 0% completion

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?

Thanks,
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