There were two scripts that were very much asked and they are how to Turning OFF or ON Query Store for All the Database? Let us learn today.
SQL SERVER – Query Store Status for All the Databases
Today we will discuss how I was able to help them with a query script of Query Store Status for All the Databases. Let us discuss today.
Forcing a Plan in Query Store and Checking That It Held
Use forcing a plan in Query Store with verified IDs, then audit force failures and runtime results every week so the fix stays useful.
SQL SERVER – Unable to Disable Query Store for Always On Database
My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
Proving a Tuning Change Worked With Before and After Numbers
Prove a tuning change with before and after numbers from Query Store for CPU, reads, duration, and comparable execution volume.
Comparing a Good and a Bad Plan for One Query in Query Store
Compare a good and a bad plan in Query Store using runtime history, SSMS Compare Showplan, estimates, joins, grants, and parallelism.
Create Efficient Query Plans Using Query Store – Analyzing SQL Server Query Plans – Part 3
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss how to Create Efficient Query Plans Using Query Store.