Question
Recommended Connection pool settings @ Tomcat8 @PRPC731 @SQL Server.
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.
Hi Pradeep,
Connection pool size would depend on your application usage and on the number of DB interaction you would typically make.
You may get to the optimal number by performing load testing and checking for PEGA0026 alerts
Regards,
Ujjwal