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…
2 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...
To access this incredible, amazing content, you gotta get Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.