© 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.