Diagnose deadlocks, lock contention, and blocking from logs and schema, then prescribe lock-order, isolation, and access-pattern fixes.
## CONTEXT My production database in 2026 is experiencing deadlocks, blocking, or lock-wait timeouts. I will share the deadlock log or graph, the transactions involved, the isolation level, and the relevant table and index structure. I want to understand exactly which locks conflicted, why the cycle formed, and how to…
Premium Prompt
Unlock this prompt — and all 30,000+ expert-crafted prompts — with Pro.
Unlock with Pro