Summary information |
|
|---|---|
Default value |
1 |
Range of values |
1 – 64, as powers of 2 |
Status |
Static |
Display level |
Intermediate |
Required role |
System administrator |
Configuration group |
Cache Manager |
global cache partition number sets the default number of cache partitions for all data caches. The number of partitions for a particular cache can be set using sp_cacheconfig; the local value takes precedence over the global value.
Use cache partitioning to reduce cache spinlock contention; in general, if spinlock contention exceeds 10 percent, partitioning the cache should improve performance. Doubling the number of partitions cuts spinlock contention by about one-half.
See Chapter 4, “Configuring Data Caches,” in the System Administration Guide: Volume 2 for information on configuring cache partitions. Also see Chapter 6, “Tuning Asynchronous Prefetch” in the Performance and Tuning Series: Basics.
