sys.dm_os_memory_cache_hash_tables

Description

Analytics Platform System (PDW) Returns a row for each active cache in the instance of SQL Server. Address (primary key) of the cache entry. Is not Name of the cache. Is not nullable. Type of cache. Is not nullable. Hash table number. A particular cache may have multiple hash tables that correspond to different hash Number of buckets in the hash table. Is not nullable. Number of buckets that are currently being used.