How to Configure SQL/Server Index Maintenance

By default, CopyStorm will periodically rebalance SQL/Server indexes based on the reported index fragmentation. While the defaults (shown below) should provide good performance in most scenarios, it may be required to change the index rebalancing behavior or to disable it altogether. The configuration can be changed by adding an XML “SqlServerDatabaseBuilder.xml” file to one of:

  • If using the CapStorm recommended directory structure, the file can be added to the “CapstormConfig” directory.
  • In all cases, the “SqlServerDatabaseBuilder.xml” file can be added to the [CopyStorm]/config/ configuration file directory.

Available options (and default values) can be found below:

Copy to Clipboard