Look at the number of items in different parts of the cache

-- Look at the number of items in different parts of the cache
SELECT name ,
[type] ,
entries_count ,
single_pages_kb ,
single_pages_in_use_kb ,
multi_pages_kb ,
multi_pages_in_use_kb
FROM sys.dm_os_memory_cache_counters
WHERE [type] = 'CACHESTORE_SQLCP'
OR [type] = 'CACHESTORE_OBJCP'
ORDER BY multi_pages_kb DESC ;