The first SQL Rally was held last week in Orlando, FL, and I had the honor of being selected for one of the spotlight sessions by the community in the DBA track. SQL Rally was a different experience from the regular PASS Summit; it wasn’t anywhere as big as the normal summit, but it was larger than most of the SQL Saturday events that I have attended. If I had to make a comparison, I would say that SQL Rally was more on par with the experience I had attending SQL Bits 7 in York, UK last October, which seems to be right about where PASS wanted the experience to be. I always enjoy attending events, large or small, where people are passionate about SQL Server.
Since the event I have had a number of requests for the presentation materials and demos I used in my Deadlocking for Mere Mortals presentation on Friday afternoon. Below is the session abstract, and attached to this blog post is a copy of the slides and demo’s for the presentation.
Title: Deadlocking for Mere Mortals
Speaker: Jonathan Kehayias
Category: Summit Spotlight
While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server 2005 and 2008, 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 2005 and 2008; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
- Understand why deadlocks occur in SQL Server
- Understand how to capture deadlock graphs in various SQL Server versions.
- Understand how to read the deadlock graph to determine the specific cause and how to mitigate against the deadlock.