In most cases, the default memory allocated to the On-Premises Connector is sufficient, allowing for a small number of open connections and simultaneous requests. However, depending on the number and complexity of concurrent requests in your environment, you might need to increase the memory allocated to the On-Premises Connector, the number of concurrent request it can process, or both, to handle the query volume. If the memory allocation and concurrent request settings are at the high end of the range, you might want to consider using multiple On-Premises Connectors and configure load balancing to share the load between the Connectors.
1. Open the Configuration Tool, and click the Resource tab.
2. Select a preset memory load from the dropdown list, or specify custom values. The default resource settings are sufficient for most On-Premises Connector installations, allowing for a small number of open connections and simultaneous requests. Note that because the values for the High and Very High settings exceed the limits of a 32-bit Windows platform, they are not available when using the On-Premises Connector on a 32-bit inmachine.
Min Memory Size (MB) specifies the minimum number of megabytes used by the On-Premises Connector's JVM. It must be less than or equal to the the Max Memory Size. The valid range is 128 to 16384.
Max Memory Size (MB) specifies the maximum number of megabytes used by the On-Premises Connector's JVM. Be sure that your system has at least this much memory available for use by the Connector. The valid range is 256 to 16384.
Concurrent Requests specifies the maximum number of concurrent requests, such as login and execute, that are supported. The valid range is 50 to 1000.
Memory Load
Minimum Memory Size (MB)
Maximum Memory Size (MB)
Concurrent Requests
Default
128
256
200
Moderate
2048
2048
500
High
4096
4096
800
Very High
8192
8192
1000
Custom
8192
8192
1000
3. Click Save to persist your settings on this and other Configuration Tool tabs. If you save your settings, then close and reopen the Configuration tool, the saved settings are displayed automatically.
