Take a Good Hard Look At SQL Server Deadlocks

SQL Server 2012 comes with tools to help DBAs analyze deadlocks visually. In this excerpt from Jonathan Kehayias' new course SQL Server: Deadlock Analysis and Prevention you'll see how to use the built-in tools as well as some third party tools for getting an eagle eye view into your deadlock and why it happened. In the full course Jonathan covers how to collect deadlock information, examples of common deadlock scenarios, and how to recover from deadlocks.

-~-~~-~~~-~~-~-
Push your limits. Expand your potential. Smarter than yesterday-
-~-~~-~~~-~~-~-