Adding cache partitions  Setting the number of local cache partitions

Chapter 4: Configuring Data Caches

Setting the number of cache partitions with sp_configure

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.




Copyright © 2005. Sybase Inc. All rights reserved. Setting the number of local cache partitions

View this book as PDF