Galaxy Repository performance considerations
- Last UpdatedAug 12, 2025
- 2 minute read
The Application Server Galaxy Repository leverages Microsoft SQL Server functionality. SQL Server enables discretion for configuring memory use thresholds.
RAM Allocation
In practice, MS SQL Server tends to monopolize and consume any RAM that is available at any point in time. SQL Server enables setting a limit (or cap) on RAM allocation so that other system resources can function without limitations. This cap can be configured either as a dynamic or fixed setting.
When the RAM allocation is known, select the ...fixed memory size option to limit RAM use to approximately half of the machine's available RAM. For example, if a machine has 1GB of RAM, set the SQL Server cap to 500MB. Setting a fixed memory size ensures the memory is always available.
Note: For recommendations on Dynamic SQL Server memory allocation, see Bulk operations considerations.
To set a fixed memory size
-
Open Microsoft SQL Server Management Studio.
-
Connect to the server.
-
Right-click on the Galaxy name in the database list and select Properties from the context menu.
-
Select the Memory tab.
-
Set the maximum memory size.
-
Click OK to close the Properties dialog box.
Auto Increment Data
The following table illustrates the increased disk space used by the default Microsoft SQL Server Auto Increment setting, based on the starting size of a typical Galaxy Repository database:
|
Auto Increment Catalyst |
Sizing |
MB |
% Increase |
|
Empty Galaxy Repository database size |
6.6 MB |
---- |
|
|
Derive "X" number of templates or instances. |
Auto-incremented size at reporting time. |
7.1 MB |
+7.5% |
|
Derive "X" more templates or instances. |
Auto-incremented size at reporting time. |
7.7 MB |
7.8% |
|
Incremental Growth Events |
---- |
---- |
---- |
|
Derive "X" more templates or instances |
Auto-incremented size at reporting time. |
11.44 MB |
+8.3% |
|
Derive "X" more templates or instances |
Auto-incremented size at reporting time. |
12.44 MB |
+ 8.7% |
|
Summary Increment Range |
---- |
---- |
+7 to 11% |
The default Auto Increment value is 10%. This means that the occupied disk space does not grow with each individual ArchestrA object template and/or object instance added to the Galaxy Repository. Instead, the disk space will grow by the specified percentage, when SQL Server determines that adding space is necessary.
In practice, the growth increments for occupied disk space vary from 7% of the Galaxy database size to 11%.
Note: The size of the increase does not correlate to a single object instance.
It is prudent to leave enough disk space available for the planned capacity of the ArchestrA Galaxy Repository. Always allow for 25-50% of projected/future capacity (unless the system is quite well-defined) then add 10% to allow for Microsoft SQL Server to automatically increment beyond that threshold, if and when the threshold is reached.