Use sp_configure to set the number of cache partitions for all caches on a server. For example, to set the number of cache partitions to 2, enter:
sp_configure "global cache partition number",2
You must restart the server for the change to take effect.
