global cache partition number

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.