Azure SQL Now Captures Read-Only Queries in the Primary Query Store
Microsoft has announced that read-only queries are now captured in the primary Query Store for Azure SQL, expanding visibility into database performance and workload behavior. Previously, Query Store focused primarily on read-write activity, leaving gaps for teams running analytics, reporting or replica-style read-only workloads. With the update, database administrators can analyze execution plans, runtime statistics and performance trends for read-only queries alongside transactional activity. Query Store can now record execution data from both primary and read-only replicas for new and existing databases, streamlining troubleshooting.
The change addresses a common challenge for teams operating mixed workloads on Azure SQL. By bringing read-only activity into the primary Query Store, Azure SQL aligns more closely with how modern applications use databases in production. For DBAs and platform engineers, the update simplifies troubleshooting, supports more accurate capacity planning, and reduces blind spots in performance optimization efforts.
Posted by Redmondmag.com Editors on 01/14/2026