Changing Default Memory Settings
You must balance the following to determine optimal memory configuration:
• Queries run faster with more memory. So, giving the server as much memory as possible is highly recommended.
• Giving the server too much memory can cause excessive paging and significantly degrade performance.
To change the default memory setting
1. Log into Studio as the admin user.
2. From the Administration menu, choose Configuration.
3. In the tree pane, navigate to TDV Server > Memory.
4. You can modify the parameter settings for the following categories:
— Managed Memory
— Sampling
5. You can also locate and modify the following configuration parameters to optimize memory settings for your system:
Configuration Parameter | Description |
Total System Memory | The total physical memory calculated on the target installation machine. |
Upper Limit of Total Available Memory | The upper limit for the total amount of Java heap (memory) available for the server's use. The default value is the total physical memory calculated on the target installation machine. |
6. Click Apply.
7. Click OK.
8. Restart the TDV Server to implement your changes.