PASS logo

2021 Summit video library

Lock Picking your SQL Engine

Shashane Welgama

Locking is an essential need to uphold data integrity. Managing locking behaviour is also important when it comes to improving transaction concurrency. In this talk, we will dive into the locking behaviour of the SQL engine.

This applies to SQL Server, Azure SQL Databases and Azure SQL Managed Instance.

We will learn how to uncover performance problems related to locks and lock escalations, when and why deadlocks happen, and the possible steps you can take to prevent deadlocks from happening. Join me in understanding the key to the SQL Engine’s locking behaviour.