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