Product has been added to your cart.

1.3 Lab 1: Fixing PAGEIOLATCH Waits

Now, it’s your turn. We’re going to start by purposely limiting your SQL Server: We’re starting with no nonclustered indexes MAXDOP is set to 1 – don’t touch that for now, because we’ll be teaching you about parallelism later Run a workload using SQLQueryStress, and while watching your wait stats, try tuning indexes and/or queries,…

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. We’re going to start by purposely limiting your SQL Server: We’re starting with no nonclustered indexes MAXDOP is set to 1 – don’t touch that for now, because we’ll be teaching you about parallelism later Run a workload using SQLQueryStress, and while watching your wait stats, try tuning indexes and/or queries,…

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.