MS SQL Recommended Settings

For increased performance and reliability, add the following properties to <local-tx-datasource> node within the rx-ds.xml file located in <perc_root>\AppServer\server\rx\deploy directory if not already present.

<maxReconnects>3</maxReconnects>
<initialTimeout>15</initialTimeout>
<autoReconnect>true</autoReconnect>
<failOverReadOnly>false</failOverReadOnly>
<new-connection-sql>SELECT 1</new-connection-sql>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>

After updating this file, the Percussion service should be fully stopped and started again for the changes to take effect.