Wait Types – PAGEIOLATCH Part 2 – Ways to Mitigate It (9 minutes)
There are four ways to solve PAGEIOLATCH problems: tune the query, tune the indexes, add memory, or make storage faster. Brent explains with demos. For more details on storage or hardware, check out our DBA training class on Storage, Hardware, and Virtualization.
To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.