Here is a curated list of Deadlock related links that I recommend visiting:
Deadlock Articles:
- Microsoft’s MSDN Article – “Detecting and Ending Deadlocks”
- Microsoft’s Premier Field Engineers – “How to Monitor Deadlocks in SQL Server”
- Gail Shaw’s guide to deadlocks
- Kendra Little Articles:
- Deadlock Code for the WorldWideImporters Sample Database
- Decoding Key and Page WaitResource for Deadlocks and Blocking
- Tracing Deadlock Graphs: Extended Events or Server Side Trace
- Setting up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17) (Note: see video below as well)
- https://littlekendra.com/2016/09/29/setting-up-free-blocking-alerts-and-deadlock-monitoring-dear-sql-dba-episode-17/
- SQL Workbooks Course:
- Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes)
- Bart Duncan’s Series of articles
- Series List: https://blogs.msdn.microsoft.com/bartd/?m=20069
- Part 1: https://blogs.msdn.microsoft.com/bartd/2006/09/08/deadlock-troubleshooting-part-1/
- Part 2: https://blogs.msdn.microsoft.com/bartd/2006/09/12/deadlock-troubleshooting-part-2/
- Part 3:https://blogs.msdn.microsoft.com/bartd/2006/09/25/deadlock-troubleshooting-part-3/
- Brent Ozar’s “The Difficulty with Deadlocks” by Jeremiah Peschka
- Michael J Swart discusses Deadlocks caused by Parameter Sniffing
- SQL Studies discusses blocking, and creates a sample Deadlock
- Merrill Aldrich’s “Transaction Isolation / Dirty Reads / Deadlocks Demo”
- Dave Mason’s “Handling SQL Server Deadlocks with Event Notifications”
- Geoff Albin’s “How to receive Deadlock information automatically via email”
Deadlock Presentations:
- Professional Association for SQL Server (requires free login)
- Deadlocking for Mere Mortals by Jonathan Keyhayias
- Deadlock Detection, Troubleshooting, and Prevention by Trevor Barkhouse
Deadlock Articles from SQL Monitoring Tools:
- Redgate’s SQL Monitor:
- General SQL Monitor Page:
- https://www.red-gate.com/products/dba/sql-monitor/
- (Quick Note: you can go into their SQL Monitor demo, check out a deadlock event, and look for the “Description” ribbon which will give you more details and information about SQL Deadlocks. You can read their tips and recommendations.)
- How to fix SQL Server Deadlocks by Grant Fritchey
- Reducing Deadlocks
- General SQL Monitor Page:
- SentryOne and Plan Explorer:
- General SentryOne Page:
- Following a single-transaction deadlock across SQL Server version
- Solarwinds’ Database Performance Analyzer
- General Deadlock Info Page:
- Interactive Demo:
- How to Resolve Common Deadlocks
Deadlock Videos:
- Grant Fritchey’s SQL Monitor and Deadlocks
- Direct YouTube Link:
- Kendra Little’s “Setting Up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)”
- Direct YouTube Link:
- Kendra Little
- Direct Vimeo Link:
- Klaus Aschenbrenner’s “SQL Server Quickie #33 – Deadlocks”
- http://www.sqlpassion.at/archive/2016/03/07/sql-server-quickie-33-deadlocks/
- Direct YouTube Link:
- Pluralsight’s “Take a Good Hard Look At SQL Server Deadlocks”
- Direct YouTube Link:
- SentryOne’s “SQL Server Deadlocks”
- Direct YouTube Link: