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
