Azure SQL Database adds version-store read metrics
Azure SQL Database now exposes version-store read metrics to help diagnose CPU overhead that ordinary logical-read statistics can hide. Counters distinguish tempdb versions, in-row and off-row persistent version-store reads, and online-index versions.
The metrics appear in SET STATISTICS IO, runtime query-plan XML, selected extended events and query, module, request and session DMVs. They help investigate blocked cleanup and longer version chains.
Query Store integration is under consideration; Azure SQL Managed Instance support is planned, and the SSMS graphical plan display will gain the metrics in a future version.
Partner briefing
- What it is
Version-store read observability in Azure SQL Database.
- What’s changing
Adds counters to statistics output, runtime plan XML, extended events and DMVs.
- Why it matters
Helps correlate row-version traversal with workload CPU and query performance.
- Who it affects
Azure SQL administrators and performance engineers.