© Enrico van de Laar 2019
Enrico van de LaarPro SQL Server 2019 Wait Statisticshttps://doi.org/10.1007/978-1-4842-4916-1_16

Latch Classes

Enrico van de Laar1 
(1)
Drachten, The Netherlands
 

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 free space 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 ...

Get Pro SQL Server 2019 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.