Common Wait Types in SQL Server

Kendra Little | October 8, 2023

It’s been super fun to refresh on Wait Stats in SQL Server, and, as usual, I’ve learned more than I expected on a familiar subject by writing it down and illustrating it.

These aren’t ALL of the common waits– this doesn’t touch on locking, parallelism, etc. – but these are some of the common ones that can be easy to confuse because of the similar names, like PAGELATCH / PAGEIOLATCH / LATCH waits.

Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.