Bonus: How to Find the Right Queries to Tune
Now that you know some of the decisions SQL Server has to make, let’s look at your SQL Server to see what kinds of decisions it’s been making lately. First, we’ll run a workload against the Stack Overflow database and use sp_BlitzCache to spot the most resource-intensive queries. Then, you’ll take a look at your…
