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.