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. |
Permissions
Requires VIEW SERVER STATE permission on the server.