How to See Rowcounts and Execution Time for In-Flight Queries in SQL Server
I frequently need to see rowcounts and execution time for queries while they’re running. Maybe I’m troubleshooting a slow query …
Read MoreJer and Kendar Explore Optimized Locking
By Kendra Little on • 1 min read
🔥 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
