PAGEIOLATCH occurs when SQL Server needs to read pages from storage. Brent explains with a query, and links it to the file IO statistics DMVs using sp_BlitzFirst (formerly known as sp_AskBrent).
Wait Types – PAGEIOLATCH Part 1 – Slow Reads from Storage (7 minutes)
PAGEIOLATCH occurs when SQL Server needs to read pages from storage. Brent explains with a query, and links it to the file IO statistics DMVs using sp_BlitzFirst (formerly known as sp_AskBrent).
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 2 – Ways to Mitigate It (9 minutes)
- Wait Types – RESOURCE_SEMAPHORE (33m)
- Wait Types – SOS_SCHEDULER_YIELD (44m)
- Wait Types – THREADPOOL (27m)
- Wait Types – WRITELOG (12m)