global cache partition number sets the default number of cache partitions for all data caches.
|
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 |
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 System Administration Guide: Volume 2 > Configuring Data Caches for information on configuring cache partitions. Also see Performance and Tuning Series: Basics > Tuning Asynchronous Prefetch.