Share via


sys.dm_os_memory_cache_counters (Transact-SQL)

Returns a snapshot of the health of a cache. sys.dm_os_memory_cache_counters provides run-time information about the cache entries allocated, their use, and the source of memory for the cache entries.

Column name

Data type

Description

cache_address

varbinary(8)

Address (primary key) of the counters associated with a specific cache. Is not nullable.

name

nvarchar(256)

Name of the cache. Is not nullable.

type

nvarchar(60)

Type of cache that is associated with this entry. Is not nullable.

single_pages_kb

bigint

Amount, in kilobytes, of the single-page memory allocated. This is the amount of memory allocated by using the single-page allocator. This refers to the 8-KB pages that are taken directly from the buffer pool for this cache. Is not nullable.

multi_pages_kb

bigint

Amount, in kilobytes, of the multipage memory allocated. This is the amount of memory allocated by using the multiple-page allocator of the memory node. This memory is allocated outside the buffer pool and takes advantage of the virtual allocator of the memory nodes. Is not nullable.

single_pages_in_use_kb

bigint

Amount, in kilobytes, of the single-page memory that is being used. Is nullable. This information is not tracked for objects of type USERSTORE_<*> and these values will be NULL.

multi_pages_in_use_kb

bigint

Amount, in kilobytes, of the multipage memory that is being used. NULLABLE. This information is not tracked for objects of type USERSTORE_<*>, and these values will be NULL.

entries_count

bigint

Number of entries in the cache. Is not nullable.

entries_in_use_count

bigint

Number of entries in the cache that is being used. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.