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.
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.
- 01. How to Measure and Change Your SQL Server – 3 Metrics to Gather (23 minutes)
- 02. Measuring Your SQL Server with sp_BlitzFirst and Monitoring Software (24 minutes)
- 03. How to Measure and Change Your SQL Server – The Parts Catalog (7 minutes)
- Wait Types – ASYNC_NETWORK_IO (7 minutes)
- Wait Types – CXPACKET (54 minutes)
- Wait Types – LCK% – Locking Snapshot RCSI Part 1 (39 minutes)
- Wait Types – LCK% – Locking Snapshot RCSI Part 2 (29 minutes)
- Wait Types – PAGEIOLATCH Part 1 – Slow Reads from Storage (7 minutes)
- Wait Types – RESOURCE_SEMAPHORE (33m)
- Wait Types – SOS_SCHEDULER_YIELD (44m)
- Wait Types – THREADPOOL (27m)
- Wait Types – WRITELOG (12m)