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). [wpc_button]
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.