When I work with Query Store, I often need to find the executions that didn’t finish successfully, queries that were aborted or ended with an exception. In the SSMS interface, you’d normally look for a square icon (client-abort) or a triangle icon (runtime error) . Trying to find those by clicking through the dashboard is slow. […]
Need to quickly spot failed query’s in Query Store? Read More »
Context A client used “ApplicationIntent=ReadOnly” in their connection string, expecting queries to execute on the secondary read-only replica. Instead, the queries were executed on the primary database, leading them to suspect an Availability Group misconfiguration. Diagnostic To confirm whether the driver sent the read-only intent, we captured the “hadr_read_only_route_preconditions” Extended Event. This event records whether
Verify “ApplicationIntent=ReadOnly” Read More »
This article covers the fifth and final step in the D-BART method, a structured approach to managing SQL Server environments. What’s in it for you? Less firefighting, more focus: Your team spends less time on repetitive tasks and more on high-impact work. Better decisions, faster: With reliable data at your fingertips, you can act on
Streamlining SQL Server management: Thrive Read More »
