David Griffiths-273839 (3/20/2013)

---

Here is my guess as to what is happening. It's only a guess since we don't have full information.

2. Evaluate whether the index on Status is actually beneficial - if there is a only small number of possible Status values the index will not be very selective. If you simply drop the index - no more deadlocks.

Any of these changes would solve your deadlock problem but might actually damage your performance or introduce other issues elsewhere. But that's just part of the fun.