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.