O'Reilly logo

Pro SQL Server Wait Statistics by Enrico van de Laar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 8

image

Latch-Related Wait Types

In the previous chapter we took a pretty deep look at locking and blocking inside SQL Server, together with different Wait Types that indicate blocking is occurring. Latches look a lot like the locks we discussed earlier; in some cases they even appear to use the same modes as the locks we discussed in the previous chapter. Make no mistake though, latches are completely different than locks, even though they seem to share some features. While locks are used to guarantee transactions are isolated and consistent, latches are used to guarantee the consistency of in-memory objects.

Latches are, just like locking ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required