PASS logo PASS Data Community Summit 2021
Host Redgate Premier sponsor Microsoft

November 8-12

Free online conference

All sessions

Lock Picking your SQL Engine

Shane Welgama

Shane Welgama

Data Engineer - i2iLogic

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.

Type: General Session (60-minutes)

Theme: Back to Basics

Track: Database Management

Level: 100 (Foundational)

Best of Summit 2020

Watch the top 2020 PASS Summit sessions from some of the best speakers in the data industry.

Watch now

Stay in touch

Sign up for news on Summit 2022 and beyond

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