Partition Database with Central Configuration

Enable Partition

For a data source, partition can be enabled from the DataSource settings in the Central Configuration as follows:

1. Enable partitioning by selecting a data source, and then selecting Enable Table Partitioning.

2. Enter appropriate path for Database Secondary Data File Path.

Database Secondary Data File Path

Ideally, the secondary database file should be on a separate file group on a different drive for optimal performance. That benefits in keeping the least used partition in a different path.

The database secondary data file path should be on a Microsoft SQL Server machine with sufficient rights to create files on the specified path. Ensure, you provide a valid path as it is not validated by the business application. If the path is not specified, then the secondary database file will be created at the default path, where the primary database file exists.

Enable Partition on an Existing Data Source

For an existing data source, partition can be enabled from the DataSource settings in the Central Configuration as follows:

3. Enable partitioning by selecting an existing data source, and then selecting Enable Table Partitioning.

4. Enter appropriate path for Database Secondary Data File Path.

For more information on Database Secondary Data File Path, see Database Secondary Data File Path.