These system procedures add the instance_name parameter to their syntax.
sp_cacheconfig includes the instance instance_name parameter so you can create, drop, or modify the size of a cache on a specific instance.
sp_cacheconfig "[cachename [,cache_size [P|K|M|G]" [,logonly | mixed ] [,strict | relaxed ] ] [, "cache_partition = [1|2|4|8|16|32|64]"] [, "instance instance_name"]
where instance_name is the name of the instance whose cache you are adjusting.
This example displays the cache for instance blade1:
sp_cacheconfig 'instance blade1'
This example sets the size of the Sales Cache size on blade1 to 100 megabytes:
sp_cacheconfig 'Sales Cache', '100M', 'instance blade1'
This example sets the size of the Sales Cache size on blade1 to 0 megabytes, effectively dropping the cache.
sp_cacheconfig 'Sales Cache', '0M', 'instance blade1'
This example displays the cache configuration for the entire cluster:
sp_cacheconfig
If you do not specify an instance_name, the cache for the cluster is displayed.
sp_poolconfig includes the instance instance_name parameter so you can create, drop, or modify the size of a buffer pool for a named cache on a specific instance.
sp_poolconfig cache_name [, "mem_size [P\K\M\G]", "config_poolK" [, "affected_poolK"]] [, 'instance instance_name']
where instance_name is the name of the instance whose buffer pool you are adjusting.
Creates a a 16KB buffer pool of size 25MB in the default data cache on instance blade1:
sp_poolconfig 'default data cache', '25M', '16K', 'instance blade1'
Displays the buffer pool configuration in the default data cache on instance blade1:
sp_poolconfig 'default data cache', 'instance blade1'
Displays the buffer pool configuration for named cache c_log on all instances in the cluster:
sp_poolconfig c_log
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'
