Allocate galaxy repository node memory

The Galaxy database resides on SQL Server, which runs on the Galaxy Repository (GR) node. In some cases, particularly when a GR node contains less than the recommended RAM amount, system performance may be impacted as SQL Server will use more CPU to compensate for the lower amount of available memory. In some cases, high CPU usage can even occur on systems configured with the recommended RAM amount. A galaxy with many objects, for example, can use more memory and cause high CPU usage.

If you notice CPU usage increasing over time to the point that is affecting system performance, we recommend that you set the SQL Server minimum memory (min server memory) to 1/3 of total physical memory. Application Server automatically configures the max server memory setting, and there is no need to manually configure it.

Example minimum server memory settings: