How to Trace Trigger Executions with Query Store and Extended Events
Triggers can be tricky to observe in SQL Server. When you need to understand exactly what a trigger is doing and what it impacts, Query Store and …
Read MoreJer and Kendar Explore Optimized Locking
🔥 UPDATE (November 2025): Microsoft has introduced optimized locking v2 with significant improvements. The new version includes Skip Index Locks (SIL) and Query Plan LAQ Feedback Persistence, which further reduce lock overhead. The improvements are most pronounced for nonclustered indexes. Optimized locking v2 is available in SQL Server 2025 and Azure SQL.
SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking.
Jeremiah Peschka joins Kendra (aka Kendar) to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”.
Prefer to explore optimized locking with a diagram? I’ve also got a little sketchnote for ya.
Podcast episode
Sketchnote of optimized locking concepts
Here’s a sketchnote style comic I drew up of what I’ve learned about the feature so far.
Right click and open in new tab for larger image
Learn more about optimized locking
Learn more about this feature online:
- Optimized locking article
- Transaction locking and row versioning guide <– A much longer read
Find more from the Dear SQL DBA Podcast and Jeremiah Peschka
This is Episode 78 of the Dear SQL DBA Podcast.
Read more from Jeremiah Peschka at facility9.com.
RELATED POSTS
