sp_cacheconfig

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.