Setting the number of local cache partitions

Use sp_cacheconfig or the configuration file to set the number of local cache partitions. This command sets the number of cache partitions in the default data cache to 4:

sp_cacheconfig "default data cache", "cache_partition=4"

You must restart the server for the change to take effect.