Configuring a Database with Range Partitions
If a database is to participate in a tiered storage scheme using range partitions, it must have the following settings:
Rebalancer enable set to
trueRebalancer Assignment Policy set to
rangeLocking set to
strictA range index established for the partition key, as described in Range Indexes and Lexicons
A partition key, as described in Defining a Range Partition Key
Range partitions, as described in Creating Range Partitions
Warning
All of the forests in a database configured for tiered storage using range partitions must be part of a partition.
For details on how to configure the database rebalancer with the range assignment policy, see the sections Range Assignment Policy, Configuring the Rebalancer on a Database, and Configuring the Rebalancer on a Forest.