Welsh Corgi (3/3/2013)
I certainly could Google Blocking Chains but do you know of a good article? I know you are probably the author. 🙂
Yes, you could google it. Right now I don't feel like pulling up google to search for you.
But what about the problem when I kill the process it is stuck at 0% complete?
How can I avoid that?
Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure, backup. Killing a normal SQL process you shouldn't have any problems. Just don't do anything silly like restarting SQL part way through a rollback or deleting the transaction log.
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