Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)