Problem

-- what is reason for the large amount of sessions (> 150) opened on the MSSQLServer database

-- how to / can we decrease this number of sessions

Resolution

* the number of session is based on the settings configured in Interchange/conf/datastoreconfig.xml

<Property key="openjpa.ConnectionProperties" value="DisableConnectionTracking=true,ReleaseHelperThreads=0,MinConnectionsPerPartition=50,MaxConnectionsPerPartition=100,ConnectionTimeoutInMs=30000,IdleMaxAgeInMinutes=10,ConnectionTestStatement=&quot;SELECT SYSDATE FROM DUAL&quot;"/>

* each Interchange node starts with those properties, so for B2Bi there are theoretically three nodes for each machine in the cluster (CN, TE, B2B), that being 150 connections (50 * 3). Plus, the ACF (Axway Clustering Framework) has a separate connection for updating heartbeats of the nodes to the DB.

* it is possible to lower this value, by modifying the properties that I've mentioned, but then you'll have to monitor closely your system as QA on B2Bi only tests with the default values. One stat to look into would be the DatabaseConnectionPool from the *stats.log files in Interchange