Deadlocking for Mere Mortals
While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Jonathan Kehayias is a SQL Server MVP and Microsoft Certified Master. He has presented at multiple conferences including PASS, SQLIntersection, SQLRally, SQLBits, and VMware Open Forum. In addition Jonathan teaches part of the SQLskills Immersion Events on Performance Tuning and on High Availability, and 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 with two young children who he can often be found goofing off with.