Allows you to display cache information for a specific instance. If you do not specify an instance_name, sp_helpcache displays information for all caches.
[sp_helpcache[cache_name [,'sizeP|K|M|G’][, 'instance instance_name’
where instance_name is the name of the instance whose cache you are investigating.
Displays cache information for all caches:
sp_helpcache
Displays the overhead for the cache C2 on instance “blade1” for size 10M:
sp_helpcache 'C2', '10M', 'instance blade1'
