Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition

When updating data in SQL Server, operators run the gambit of incurring issues if not done correctly. Sometimes, they manifested as lock escalation, the dreaded blocking, disastrous deadlocks, or poor performance. With the release of Optimized Locking in Azure SQL Database, issues are mitigated while helping to enhance performance and transactional concurrency. In this quick 10-minute episode of Data Exposed, we’ll showcase how this new feature helps prevent those manifestations!

Chapters:
00:00 - Introduction
02:56 - In today's world
04:54 - Current Locking
05:22 - With Optimized Locking
07:50 - Optimized Locking
09:40 - Gotchas

Recommended resources:

About John Morehouse:

About MVPs:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer

[PrimephotoStudio]

I would like to thank Anna Hoffman & John Morehouse for their time, the video was very helpful. I like when you talk about Accelerated Database Recovery.

[judagiricheithanya]

Does this feature reduce or eliminate the deadlock scenario?