Find the worst query with Query Store totals, compare CPU and duration over the last day, inspect plans, and choose the first tuning target.
Optimized Plan Forcing: Cutting Compile Time in SQL Server 2022
Check optimized plan forcing in SQL Server 2022 through scoped configuration and Query Store replay flags, then compare compile duration.
Query Store Quiz: Where Is Last Week’s Slow Query?
This Query Store Quiz starts with a slow query from last week and a plan cache that restarted empty. The answer is Query Store, which keeps plans and run times inside the database. A tested T-SQL script finds the query, its plan and its duration.
Caching Query Results in the Application
Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.
Azure SQL Database for the On-Premises DBA
Azure SQL database for the on-premises DBA changes patching and backups, while leaving query tuning, access, cost, and recovery checks with your team.
Force a Plan With Query Store: Undo a Bad Plan in Minutes
Force a plan with Query Store when a query turns slow after a plan change. This post builds a regression, finds both plans in Query Store, forces the good one, measures what forcing costs and shows when to unforce.
Assessing a Database Before a Migration
Assessing a database before a migration covers features in use, compatibility, size, dependencies, and the evidence needed before a date is promised.