Jeff Moden (4/30/2012)
There's a good chance that when a "rollback" hangs up like this, that it's waiting on something in another spid to complete. It's sometimes difficult to find but you need to find that spid and kill it in order for the spid you killed to complete its rollback.
If it was a normal query, I'd agree with you, but to run checkDB with a repair option, the DB would have had to be in single user mode. Could have been waiting for a non-SQL resource (eg IO)
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