Most Popular Latches

SQL Server Latch Waits

Some SQL Server latches can come into contention with one another. This is intended and necessary as part of the need to serialize access. However, as with locking, this does raise the prospect of blocking, and consequently latch waiting.

Read More

SQL Server Latch Types

There are hundreds of different types of SQL Server latches. Latch waits will occasionally show up in sys.dm_os_wait_stats, but you have to actively search for them.

Read More