Transaction Was Deadlocked - Chosen as Deadlock Victim

Two or more transactions held locks that blocked each other in a cycle, and the deadlock monitor terminated this transaction to break it. The application should catch this error and retry the transaction. Capture a deadlock graph (via the system_health session or a trace) to identify and reduce the lock contention.