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.