sys.dm_os_memory_cache_counters (Transact-SQL)
Returns a snapshot of the health of a cache in SQL Server 2012. 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) |
Indicates the address (primary key) of the counters associated with a specific cache. Is not nullable. |
|
name |
nvarchar(256) |
Specifies the name of the cache. Is not nullable. |
|
type |
nvarchar(60) |
Indicates the type of cache that is associated with this entry. Is not nullable. |
|
pages_kb |
bigint |
Specifies the amount, in kilobytes, of the memory allocated in the cache. Is not nullable. |
|
pages_in_use_kb |
bigint |
Specifies the amount, in kilobytes, of the memory that is allocated and in use in the cache. Is nullable. Values for objects of type USERSTORE_<*> are not tracked. NULL is reported for them. |
|
entries_count |
bigint |
Indicates the number of entries in the cache. Is not nullable. |
|
entries_in_use_count |
bigint |
Indicates the number of entries in the cache that is being used. Is not nullable. |
