Hi Team,

Could you please provide the recommended Connection pool settings for the below mentioned environment configuration.

PRPC731,Tomcat 8.5.13 and SQL Server.

Also find the current context.xml connection pool settings below.

<Resource maxWaitMillis="10000" maxIdle="30" maxTotal="100" password="ABCD" username="ABCD" url="jdbc:sqlserver://ABCD.CORP.AGP.ADS\PEGA;databaseName=ABCD;SelectMethod=cursor;SendStringParametersAsUnicode=false" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" type="javax.sql.DataSource" auth="Container" factory="dbencryption.EncryptedDataSourceFactory" name="jdbc/PegaRULES"/>

Please suggest if we need to add up any additional settings or change in values.