Databases

This topic is only applicable to on-premises installations.

Periodically review and perform appropriate maintenance on the Microsoft SQL Server and configuration settings. As data volume grows, an improperly configured or maintained Database Server can negatively impact the overall performance of Archer.

Follow these suggestions for SQL Server maintenance within the SQL Server Management tool:

• Run a currently-supported version of SQL Server with the most recent service pack from Microsoft. To determine if your software is current, see Software Recommendations.
• Set Max Degree of Parallelism to 1. This is generally applicable to a Database Server dedicated to Archer.
• Configure the Database Server for 1 tempdb data file per physical CPU core, up to a maximum of eight tempdb data files.
• Set regular processes to back up both the Instance Database and the Configuration Database.
• Set regular processes to rebuild the Instance Database's indexes and update statistics.
• Implement regular processes to manage the transaction log properly when the recovery model for the Instance Database is not set to Simple.
• Set Auto Shrink for the Instance Database to False.
• Set Autogrowth to absolute amounts instead of percentages. This setting exists for data and log files in both the Instance Database and the temporary database.