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. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Compatibility Support
In SQL Server 2012, the following columns have been renamed.
Previous Column Name |
New Column Name |
|---|---|
single_pages_kb |
pages_kb |
multi_pages_kb |
pages_in_use_kb |
In SQL Server 2012, the following columns have been removed.
single_pages_in_use_kb
multi_pages_in_use_kb
See Also
Reference
Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)