Fighting deadlocks with DevOps techniques With Kendra Little

PRESENTATION
Deadlocks are a difficult problem to resolve: you need to determine the best way to alert when deadlocks strike, the right information to gather to find the root cause of a deadlock and identify repeat offenders, and the best way to prevent a frequent deadlock from recurring. In this session, Kendra Little will show you how to generate a particularly troublesome deadlock. You'll see why deadlock graphs are your best tool to decipher deadlocks, and how the TSQL Debugger in SSMS helps you create a test case for the race condition behind the deadlock. We'll discuss why snapshot isolation can be a great tool for solving the trickiest deadlocks, and the key conditions you need to monitor when implementing snapshot isolation. Finally, we'll bring the solution together and simulate fixing the deadlock using DevOps methods.

BIO
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.