Since the App Control Server database is relatively large, SQL Server will take all the RAM it has at its disposal, potentially leading to system memory starvation. For that reason, a SQL Server memory cap should always be set on SQL Server. On systems with 16GB RAM, set the memory cap to 12GB. For systems with more RAM, make sure that the SQL maximum server memory is set to at least 5 GB less than the total RAM installed in the system for SQL Server Standard, and 10 GB for SQL Server Enterprise edition.

Note: In a small configuration with SQL Server Express, there is no need to set a SQL memory cap because SQL Server Express already limits memory use to 1 GB.