Setting Aggregation Service Memory Configurations

After installing the Aggregation Service, set memory configurations for your environment based on the following guidelines:

Table 9-1 Aggregation Service Memory Sizing

Load Guideline	RAM	maxJobExecution	readThreadPoolSize	processThreadPoolSize	writeThreadPoolSize	cacheSize
Total Number of Users: 1 Concurrent Users: 1 Queries at Peak Times: 1	8 GB	2	10	2	10	25
Total Number of Users: 500 Concurrent Users: 12 Queries at Peak Times: 12	16 GB	3	15	5	15	35
Total Number of Users: 1000 Concurrent Users: 25 Queries at Peak Times: 25	40 GB	5	30	5	30	65

1. On the server hosting the Aggregation service, open INSTALLATION_DIR/AnalysisAggregation/config/aggregation.conf in a text editor.
2. Set the value of wrapper.java.additional.2 to the RAM allocation for the service in megabytes. For example, if you are allocating 8 GB of RAM, enter -Xmx8192M,
3. Open INSTALLATION_DIR/AnalysisAggregation/config/aggregation.properties in a text editor.
4. Set the values for maxJobExecution, readThreadPoolSize, processThreadPoolSize, and writeThreadPoolSize.
5. Open INSTALLATION_DIR/AnalysisAggregation/config/db.xml in a text editor.
6. Set the value for cacheSize.
7. Restart the server.