Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition
Published Apr 02 2024 10:44 AM 906 Views
Microsoft

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!

 

Watch on Data Exposed

 

Resources:

Optimized locking

 

View/share our latest episodes on Microsoft Learn and YouTube!

Co-Authors
Version history
Last update:
‎Apr 02 2024 10:44 AM
Updated by: