PAGELATCH, PAGEIOLATCH, and LATCH Waits in SQL Server
Category:
monitoring-troubleshooting
, sql-server
I’ve long found it tricky to remember and explain the differences between three similar-sounding waits in SQL Server that all have “LATCH” in the name: PAGELATCH, LATCH, and PAGEIOLATCH waits.
Here’s an illustration that explains these waits, along with wait subtypes.