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 Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

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 Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Fundamentals of Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}