August 5, 2002 at 2:39 am
Hey Guys,
We had a EM session crash while it was opening a view. As this view was a multi table join, it held locks on several tables.
This process blocked a few other processes (scheduled jobs). I could not kill the "Blocking" Process. Fortunately, for us, the server was to be shut down for a bit of maintenance work, but why would the Kill command not work?
I was logged into QA when I tried. I have full SA rights. I also tried this from the prod box logged in as SA with no joy. I remember reading that when you issue a Kill command, the cmd field in sp_who should read something along the lines of Killed/Rolling back, but it just said "SELECT".
Any idea's on this?
Thanks,
Clive Strong
August 5, 2002 at 9:40 am
It must rollback a transaction, so it may have been stuck. I'd bet that it would have eventually killed the process, but I have seen things hang and a reboot required.
FYI, if I automate something that needs to kill a process, I usually run it 3 or 4 times with a few seconds delay to let things rollback. They sometimes don't immediately.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply