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.