Anteckning
Å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. 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.
See Also
Reference
Dynamic Management Views and Functions
SQL Server Operating System Related Dynamic Management Views