PASS logo

November 14-17

In person. In Seattle

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.

Get updates

Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.

Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.