Optimize SQL Server configuration

The default configuration of SQL Server is not optimized for JD Edwards EnterpriseOne. You must apply the appropriate configurations to ensure the optimal performance for EnterpriseOne running on a SQL Server database. The following sections describe these settings in detail.

Topics

• Adjust memory settings

• Adjust CPU settings

• Enable instant file initialization

• Configure data compression

• Add and balance data files

• Configure RCSI

• Move tempdb to instance storage

• Enable delayed durability