Configuring On-Premises Connector memory resources

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 requests 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 (this may be configured with the Connector API).

  1. Open the Configuration Tool, and click the Resource tab.
  2. Select a preset memory load from the dropdown list, or specify custom values.

    Note:

    • The default resource settings are sufficient for most On-Premises Connector installations, allowing for a small number of open connections and simultaneous requests.
    • 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 machine.

    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.

  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.
  4. Click Close to exit the Configuration Tool.