Huge Performance Improvement - Support Center Plus for Linux and Windows

We have 500+ techs working on our installation of support center plus. We regularly were hitting system limits with the DB pool, java VM stack and jboss web threads. After days of trying different tuning parameters our system would either fail regularly with thrashing java threads or our goliath db server would fall over from too many concurrent operations. This was with versions 7903 - 7905. So, watching the db connection pool we discovered that support center was not managing the DB connection pool properly. The pool had stale connectors and these were not recycling. Looking at /$SCHOME/server/default/deploy/mssql-ds.xml (MS Sql server) I saw that there were a number of parameters missing that should be in there for validating the connections in the tomcat connection pool. Here are the settings that changed our environment from crashing every 15 minutes to staying up and supporting 500 hits per second and 500 concurrent users.

Shut your system down and add this right before the </local-tx-datasource>. This will keep your db load low thanks to the query caching at connector level, and keep your db connections low thanks to the validation. Enjoy!

<min-pool-size>5</min-pool-size>
<max-pool-size>219</max-pool-size>
<track-statements>nowarn</track-statements>
<connection-property name="autoReconnect">true</connection-property>
<idle-timeout-minutes>1</idle-timeout-minutes>
<background-validation>true</background-validation>
<background-validation-minutes>1</background-validation-minutes>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<prepared-statement-cache-size>30</prepared-statement-cache-size>