Summary information |
|
|---|---|
Default value |
1 |
Range of values |
1-64, as powers of 2 |
Status |
Static |
Display level |
Intermediate |
Required role |
System Administrator |
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 with 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 “Adding cache partitions” for information on configuring cache partitions. See “Tuning Asynchronous Prefetch” in the Performance and Tuning Guide: Optimizer and Abstract Plans for information.
