Installation Note 49375: How to set MaxActive and MaxIdle for the DataFlux® Federation Server connection pool for SAS® Real-Time Decision Manager
SAS Real-Time Decision Manager / SAS® Decision Services enables you to configure the number of connections that it keeps open to the DataFlux Federation Server. You might need to adjust this number in order to get the optimal setting for performance in your environment. The number of connections is controlled by two parameters: MaxActive and MaxIdle. Follow the steps below to tune these settings.
- Log on to SAS® Management Console as an administrative user.
- Click the Folders tab.
- Expand System ► Applications ► SAS Decision Services ► Decision Services 5.5.
- Select the repository folder for the repository where you want to make the change.
- Right-click SAS_Activity_Resource from the right-hand pane.
- Select Edit System Resource....
- Ensure that MaxActive and MaxIdle are checked. Adjust their values in the Value column. A general rule of thumb is MaxActive=MaxIdle= 2*(# of CPUs on the computer where DataFlux Federation Server is installed). If the amount of time spent doing I/O in your DS2 Activities is large, then you might need to increase this number in order to get optimal performance. If the time spent on computation is large compared to the time spent doing I/O, you might want to decrease this number.
Be sure to apply the hot fix mentioned in SAS Note 49227 in order to avoid contention issues when loading DS2 Activity code on each DataFlux Federation Server connection.
Operating System and Release Information
SAS System | SAS Real-Time Decision Manager | Microsoft® Windows® for x64 | 5.41 | | 9.3 TS1M2 | |
64-bit Enabled AIX | 5.41 | | 9.3 TS1M2 | |
64-bit Enabled Solaris | 5.41 | | 9.3 TS1M2 | |
HP-UX IPF | 5.41 | | 9.3 TS1M2 | |
Linux for x64 | 5.41 | | 9.3 TS1M2 | |
Solaris for x64 | 5.41 | | 9.3 TS1M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Installation Note |
Priority: | high |
Date Modified: | 2013-04-26 12:00:14 |
Date Created: | 2013-03-07 13:05:34 |