Episode
Introduction to Optimized Locking in Azure SQL Database | Data Exposed: MVP Edition
with Anna Hoffman, John Morehouse
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
Related episodes
- Data Exposed | Microsoft Learn
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- John Morehouse | Twitter/X: @sqlrus
- AzureSQL | Twitter/X: @azuresqltw
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
Related episodes
- Data Exposed | Microsoft Learn
- To check out even more Data Exposed episodes, see our Data Exposed playlist on YouTube
- Microsoft Azure SQL
- Microsoft SQL Server
- Microsoft Developer
Connect
- Anna Hoffman | Twitter/X: @AnalyticAnna
- John Morehouse | Twitter/X: @sqlrus
- AzureSQL | Twitter/X: @azuresqltw
Have feedback? Submit an issue here.