Configuring Memory Usage

Some SQL operations, when applied to non-SQL data, require data to be cached temporarily before they can be completed. You can configure the Memory Manager feature in the connector to restrict the amount of RAM or disk space that the connector can use to cache data. For more information, see Memory Manager.

Important:
  • Editing the Windows Registry incorrectly can potentially cause serious, system-wide problems that may require re-installing Windows to correct.
  • By default, when data is cached as a file on disk, it is stored as unencrypted data. For information about encrypting this data to prevent security risks, see EncryptSwapFile.
  • Be aware that these settings apply to every connection that uses the Simba Salesforce Marketing Cloud ODBC Driver.

To configure memory usage:

  1. Using Regedit, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Simba\Simba SalesforceMarketingCloud ODBC Driver\Driver registry key.
  2. Set the values as follows:
    3. Key Value

    MemoryManagerMemoryLimit

    The maximum amount of RAM in megabytes (MB) that the connector can use to cache data for SQL operations.

    MemoryManagerThresholdPercent

    The maximum percentage of the memory limit that can be used by an existing operation. The remaining memory limit is reserved for new operations.

    MemoryManagerStrategy

    One of the following numbers specifying how the connector restricts RAM usage and manages operations when more RAM is required:

    • 1: The connector does not use any disk space to support SQL operations.
    • 2: The connector restricts the amount of RAM that each operation can use, and uses swap files to support operations if more memory is required.
    • 3: The connector allows the first SQL operation to consume as much RAM as necessary from the amounts specified by the memory limit and threshold, while subsequent operations use the remaining amount.

    SwapFilePath

    The full path to the directory where the connector creates swap files to temporarily cache data on disk.

    MemoryManagerSwapDiskLimit

    The maximum total size of all the swap files, in megabytes (MB).

    When this option is set to 0, there is no limit to the size of the swap files.

    For more information about each of these settings, including recommendations for setting the MemoryManagerStrategy property, see Configuration Options Having Only Key Names.

  3. Save the changes to the registry file.

Related topics