Killing in the Name

thatjeffsmith Database Stuff 3 Comments

Do you take pleasure in killing peo…people’s sessions in the database? If so, you are not alone. If you have Blocking Locks, the easiest way to fix that is kill the offending session and free up the requested resource. But, who should win this battle? What transactions take precedence? Should the business analyst have his report kiboshed because a developer …