Kendra LIttle gives us a sneak peek:
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.
This is an excerpt from my new comic, “Wait Stats in SQL Server.”
Click through for the excerpt, as well as some more detail on these latch types.