sp_helpcache provides information about a cache and the entities bound to it when you provide the cache name.
For example:
sp_helpcache 'sales_cache' --------------------------
Cache Name Config Size Run Size Overhead------------------ ----------- ---------- ---------- sales_cache:SALES_INSTANCE 50.00 Mb 50.00 Mb 6.39 Mb (1 row affected) --------------Cache Binding Information: -------- Cache Name Entity Name Type Index Name Status ---------- ----------- ---- ---------- sales_cache SALES database V (return status = 0)
See Reference Manual: Procedures for the sp_helpcache syntax.