Raise a compatibility level safely by capturing a Query Store baseline, changing one database, comparing plans, and keeping a tested reversal.
SQL SERVER – Get Query Plan Along with Query Text and Execution Count
A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.
Measure CPU Pressure in SQL Server with Waits and Schedulers
CPU Pressure means tasks are ready to run but every scheduler is busy, so they wait in a queue. This post reads that queue from the schedulers, compares signal waits with resource waits, checks recent CPU history and finds the queries that use the most CPU. It ends with a plain way to decide between a faster CPU, more cores and better queries.
Calculating the Cost of a Slow Query
Cost of a slow query includes frequency, CPU, reads, waits, and user time; learn to turn SQL Server measurements into a practical tuning priority.
Resource Governor: Capping a Runaway Report
Capping a runaway report with Resource Governor uses workload groups, pools, and a tested classifier to limit one workload safely.
Columns With No Statistics: Read Each Warning
A columns-with-no-statistics warning needs a column-by-column investigation. Compare warning lists before and after targeted statistics creation, and check the actual query behavior before deciding that a missing statistic caused poor performance.
SQL Server – Understanding Table Hints with Examples – 2
A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.