Product has been added to your cart.

1.5 Lab 2: CPU-Intensive Workload

Now, it’s your turn, and this time you can choose your own adventure. You can either: Tune usp_GetUsersByLocation to use <50ms of CPU time, or Run SQLQueryStress to fire off an entire workload, then figure out what changes you need to make to the queries, indexes, and tables to get the workload to finish in…

To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.

Now, it’s your turn, and this time you can choose your own adventure. You can either: Tune usp_GetUsersByLocation to use <50ms of CPU time, or Run SQLQueryStress to fire off an entire workload, then figure out what changes you need to make to the queries, indexes, and tables to get the workload to finish in…

To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.