The main bottleneck for the SQL Server performance is its database storage. In order to ensure fast storage performance, these steps should be followed:

  1. Storage should meet the requirements specified in the OER
  2. SQL Server physical storage must be dedicated to the App Control Server database. Do not put other applications, OS files or data on this storage.
  3. Exclude the SQL Server data directories from your AV scanners or other tools that might impact the disk performance.
  4. Use the CBPTest Tool - Disk Performance Testing Tool to validate that the performance of underlying storage satisfies requirements outlined in OER.