Setting Deadlock Priority

Deadlocks don't usually happen often, but when they do it's often critical that certain statements survive the deadlock. This video shows you how to make sure important sql statements are givin priority over others if a deadlock occurs by using SET DEADLOCK_PRIORITY

Jonathan Kehayias is currently employed as a Principal Consultant and Trainer for SQLskills, one of the best-known and most respected SQL Server training and consulting companies in the world. Jonathan is a SQL Server MVP and one of the few Microsoft Certified Masters for SQL Server 2008, outside of Microsoft. Jonathan frequently blogs about SQL Server, presents sessions at PASS Summit, SQLBits, S...

Gabor Kis on 2/3/2009

Short to the point! Excellent

michael on 2/3/2009

Great stuff. Is the code avaliable to add to a personal library ?

Alex Cruz on 2/3/2009

Very good

Michael on 2/3/2009

Explanation is unclear with regard to which process (low/high cost) would be deadlocked out by SQL Server when priorities are the same.

Jonathan Kehayias on 2/4/2009

Michael, When the priorities are set the same, then the processes are evaluated as if the Deadlock_Priority hadn't been explicitly set, and the process lowest estimated cost to rollback is selected as the victim.

Prasanna Prabhu on 5/1/2009

Excellent Video

yeskay on 7/8/2010

Very crisp and clear. thanks

revanth on 7/7/2011

excellent , liked it

Srinivas Alagarsamy on 7/7/2011

Nice article as always!

Yuri on 7/7/2011

Very usefull, thanks

Robi on 7/7/2011

Nice tidbit.

Carlos B. Vasquez on 7/13/2011

Glad to know about the deadlock priority.

Zarir Patel on 7/14/2011

It is a simple yet effictive way to get your important query processed. quite uesful tip.

Maurice Ivory on 11/22/2011

It was okay, but thought it say highest expensive cost!!