Deadlocking for Mere Mortals

Summary:

Although troubleshooting deadlocks has gotten easier in SQL Server, it continues to be a constant source of questions.

Learn how to simplify deadlock analysis and resolution.

This session will look at the most common deadlocks and how to troubleshoot them using methods available in SQL Server:

Trace Flags
SQL Trace
Event Notifications
Extended Events

We’ll also take a quick look at how SentryOne tools can automate deadlock collection, simplify analysis, and help you make your environment deadlock-free.

Interested in additional SentryOne webinars? Check our webinar library.

Available On Demand

Jonathan Kehayias

Principal Consultant at SQLskills | SQL Server MVP, SQLSkills

Jonathan is a Principal Consultant at SQLskills, a SQL Server MVP, and Microsoft Certified Master. He has presented at multiple conferences, including PASS, SQLIntersection, SQLRally, SQLBits, and VMware Open Forum. He teaches part of the SQLskills Immersion Events on performance tuning and high availability, and he used to teach the SQL Server portion of the Microsoft Certified Master – SharePoint certification for Microsoft. Jonathan is also a Drill Sergeant in the U.S. Army Reserves and did a tour of duty in Iraq in 2004. He’s married and has two young children who he can often be found goofing off with.

Aaron Bertrand

Product Manager at SentryOne | Microsoft MVP, SentryOne

Aaron is a Product Manager at SentryOne, with industry experience dating back to Classic ASP and SQL Server 6.5. He is editor-in-chief of the performance-related blog, SQLPerformance.com, and serves as a community moderator for the Database Administrators Stack Exchange.

Aaron's blog focuses on T-SQL bad habits and best practices, as well as coverage of updates and new features in Plan Explorer, SentryOne, and SQL Server.

Webinar: