Setting the number of cache partitions with sp_configure  Precedence

Chapter 4: Configuring Data Caches

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.





Copyright © 2005. Sybase Inc. All rights reserved. Precedence

View this book as PDF