Customizing the Maximum Connection Pool Size

You can customize the maximum number of active connections allowed from the BI Gateway runtime to the Data Store. This should only be set if, for example, your model configuration has many measures, each (or some) with a high number of calculations and many data sources. In other words, it should not be changed unless your BI Gateway Runtime experiences time-outs due to connections that are waiting for an open connection from the connection pool.

For example, a BI Gateway model with many measures, each with many calculations, can affect the 100 simultaneously active connections because BI Gateway is optimized to process measure calculations simultaneously.

When the Intelligence service establishes a 'connection pool' to the Data Store, it uses the Max Pool Size connection string parameter of ADO.NET (see reference below). The value for the Max Pool Size is adjustable through the EMIRuntimeConfigurator.xml file by providing a setting suitable for the requirements of your BI Gateway Model. For more information, refer to https://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.110).aspx.

To configure the MaxPoolSize setting

1. Open the EMIRuntimeConfigurator.xml file in a notepad editor from the BI Gateway Installation Bin directory. For example: C:\Program Files (x86)\Wonderware\Intelligence\Bin.

2. Edit the XML file and update the following information as per your requirement:

   <MaxPoolSize>100</MaxPoolSize>

   Note: The minimum value for MaxPoolsize is 100 but there is no maximum limit. However, it is recommended that one should not use an extremely high value Max Pool Size. Lab tests have shown that a Max Pool Size of 500 is sufficient and can eliminate any timeouts for complex configurations.

3. Save and close the file.

4. Restart the Intelligence Runtime service in order for the MaxPoolSize setting to take effect after changing this setting in the EMIRuntimeConfigurator.xml file.