The main bottleneck for the SQL Server performance is its database storage. In order to ensure fast storage performance, these steps should be followed:
- Storage should meet the requirements specified in the OER
- 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.
- Exclude the SQL Server data directories from your AV scanners or other tools that might impact the disk performance.
- Use the CBPTest Tool - Disk Performance Testing Tool to validate that the performance of underlying storage satisfies requirements outlined in OER.