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

APPENDIX III

image

Latch Classes

Latch class

Books Online Description

Additional Information

ALLOC_CREATE_RINGBUF

Used internally by SQL Server to initialize the synchronization of the creation of an allocation ring buffer.

Used when creating a ring buffer. A ring buffer briefly holds internal event information in memory and is used for diagnostics.

ALLOC_CREATE_FREESPACE_CACHE

Used to initialize the synchronization of internal freespace caches for heaps.

Allocates free space for heaps (tables without a clustered index)

ALLOC_CACHE_MANAGER

Used to synchronize internal coherency tests.

 

ALLOC_FREESPACE_CACHE

Used to synchronize access to a cache of ...

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