sys.dm_os_memory_cache_hash_tables

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.

Permissions

Requires VIEW SERVER STATE permission on the server.