To kill source blocked session automatically?

Last Post 02 Dec 2010 10:26 AM by ufohj. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ufohj
New Member
New Member

--
02 Dec 2010 08:46 AM
Hi,

How to kill the source blocked session automatically before it raises lots of deadlocks?

Does anybody has a script to do so?

Thanks.
gunneyk
New Member
New Member

--
02 Dec 2010 09:58 AM
The chances of you killing the lead blocker before a deadlock are slim to none. You can't just go killing a blocking session assuming it will deadlock as nothing will get acomplished. The answer is to determine why you are having deadlocks int he first place and address that.

http://blogs.msdn.com/b/sqlserverst...17960.aspx
http://blogs.msdn.com/b/bartd/archi...art-1.aspx
ufohj
New Member
New Member

--
02 Dec 2010 10:26 AM
Thanks gunneyk.

You are not authorized to post a reply.

Acceptable Use Policy