Prevention vs. Detection
Prevention might abort too many Xacts.
Detection might allow deadlocks to tie up resources for a while.
- Can detect more often, but it’s time-consuming.
The usual answer:
- Detection is the winner.
- Deadlocks are pretty rare.
- If you get a lot of deadlocks, reconsider your schema/workload!