Deadlocks

Here is a curated list of Deadlock related links that I recommend visiting:

Deadlock Articles:

• Microsoft’s MSDN Article – “Detecting and Ending Deadlocks”
  • https://msdn.microsoft.com/en-us/library/ms178104.aspx
• Microsoft’s Premier Field Engineers – “How to Monitor Deadlocks in SQL Server”
  • https://blogs.technet.microsoft.com/mspfe/2012/06/28/how-to-monitor-deadlocks-in-sql-server/
• Gail Shaw’s guide to deadlocks
  • https://www.red-gate.com/simple-talk/sql/performance/sql-server-deadlocks-by-example/
• Kendra Little Articles:
  • Deadlock Code for the WorldWideImporters Sample Database
    • https://littlekendra.com/2016/09/13/deadlock-code-for-the-wideworldimporters-sample-database/
  • Decoding Key and Page WaitResource for Deadlocks and Blocking
    • http://littlekendra.com/2016/10/17/decoding-key-and-page-waitresource-for-deadlocks-and-blocking/
  • Tracing Deadlock Graphs: Extended Events or Server Side Trace
    • http://littlekendra.com/2016/12/27/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)
      • https://sqlworkbooks.com/course/troubleshooting-blocking-and-deadlocks-for-beginners/
• 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
  • https://www.brentozar.com/archive/2011/07/difficulty-deadlocks/
• Michael J Swart discusses Deadlocks caused by Parameter Sniffing
  • http://michaeljswart.com/2015/02/when-parameter-sniffing-caused-deadlocks/:
• SQL Studies discusses blocking, and creates a sample Deadlock
  • https://sqlstudies.com/2015/07/01/blocking-and-deadlocking-on-purpose/
• Merrill Aldrich’s “Transaction Isolation / Dirty Reads / Deadlocks Demo”
  • http://sqlblog.com/blogs/merrill_aldrich/archive/2009/07/29/transaction-isolation-dirty-reads-deadlocks-demo.aspx
• Dave Mason’s “Handling SQL Server Deadlocks with Event Notifications”
  • https://itsalljustelectrons.blogspot.com/2017/06/Handling-SQL-Server-Deadlocks-With-Event-Notifications.html
• Geoff Albin’s “How to receive Deadlock information automatically via email”
  • http://www.sqlservercentral.com/articles/deadlocks/71374/

Deadlock Presentations:

• Professional Association for SQL Server (requires free login)
  • Deadlocking for Mere Mortals by Jonathan Keyhayias
    • http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit
    • PDF Download of Materials:
      • http://www.pass.org/DesktopModules/OratorData/API/SessionMaterial/Download?id=3334&type=2
  • Deadlock Detection, Troubleshooting, and Prevention by Trevor Barkhouse
    • http://www.pass.org/Learning/Recordings/Listing.aspx?category=Summit

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
    • https://www.red-gate.com/products/dba/sql-monitor/resources/articles/monitor-sql-deadlock
  • Reducing Deadlocks
    • https://documentation.red-gate.com/sm4/troubleshooting/questions/reducing-deadlocks
    • https://documentation.red-gate.com/sm7/advanced-operations/reducing-deadlocks
• SentryOne and Plan Explorer:
  • General SentryOne Page:
    • https://www.sentryone.com/sql-server/sql-deadlock
  • Following a single-transaction deadlock across SQL Server version
    • https://sqlperformance.com/2013/11/t-sql-queries/single-tx-deadlock
• Solarwinds’ Database Performance Analyzer
  • General Deadlock Info Page:
    • https://www.solarwinds.com/topics/sql-server-deadlocking?CMPSource=THW&CMP=REFDOM
  • Interactive Demo:
    • http://database.demo.solarwinds.com/iwc/login.iwc
  • How to Resolve Common Deadlocks
    • https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/Deadlock_analysis_in_DPA

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: