global cache partition number

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.