sys.dm_os_memory_cache_hash_tables (Transact-SQL)
Returns a row for each active cache in the instance of SQL Server.
Column name | Data type | Description |
|---|---|---|
cache_address | varbinary(8) | Address (primary key) of the cache entry. Is not nullable. |
name | nvarchar(256) | Name of the cache. Is not nullable. |
type | nvarchar(60) | Type of cache. Is not nullable. |
table_level | int | Hash table number. A particular cache may have multiple hash tables that correspond to different hash functions. Is not nullable. |
buckets_count | int | Number of buckets in the hash table. Is not nullable. |
buckets_in_use_count | int | Number of buckets that are currently being used. Is not nullable. |
buckets_min_length | int | Minimum number of cache entries in a bucket. Is not nullable. |
buckets_max_length | int | Maximum number of cache entries in a bucket. Is not nullable. |
buckets_avg_length | int | Average number of cache entries in each bucket. Is not nullable. |
buckets_max_length_ever | int | Maximum number of cached entries in a hash bucket for this hash table since the server was started. Is not nullable. |
hits_count | bigint | Number of cache hits. Is not nullable. |
misses_count | bigint | Number of cache misses. Is not nullable. |
buckets_avg_scan_hit_length | int | Average number of examined entries in a bucket before the searched for an item was found. Is not nullable. |
buckets_avg_scan_miss_length | int | Average number of examined entries in a bucket before the search ended unsuccessfully. Is not nullable. |
