Displays information about the objects that are bound to a data cache or the amount of overhead required for a specified cache size.
sp_helpcache {cache_name | "cache_size[P|K|M|G]"}
is the name of an existing data cache.
specifies the size of the cache, specified by P for pages, K for kilobytes, M for megabytes, or G for gigabytes. The default is K.
Displays information about items bound to pub_cache:
sp_helpcache pub_cache
Shows the amount of overhead required to create an 80MB data cache:
sp_helpcache "80M"
Displays information about all caches and all items bound to them:
sp_helpcache
To see the size, status, and I/O size of all data caches on the server, use sp_cacheconfig.
When you configure data caches with sp_cacheconfig, all the memory that you specify is made available to the data cache. Overhead for managing the cache is taken from the default data cache. The sp_helpcache displays the amount of memory required for a cache of the specified size.
To bind objects to a cache, use sp_bindcache. To unbind a specific object from a cache, use sp_unbindcache. To unbind all objects that are bound to a specific cache, use sp_unbindcache_all.
The procedure sp_cacheconfig configures data caches. The procedure sp_poolconfig configures memory pools within data caches.
sp_helpcache computes overhead accurately up to 74GB.
Any user can execute sp_helpcache.
System procedures sp_bindcache, sp_cacheconfig, sp_poolconfig, sp_unbindcache, sp_unbindcache_all
