Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 PRADEEP CHOWDARY PYDI (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
US
PradeepPydi Member since 2017 240 posts
Anthem
Posted: Jul 2, 2018
Last activity: Jul 3, 2018
Posted: 2 Jul 2018 19:11 EDT
Last activity: 3 Jul 2018 4:11 EDT
Closed

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.

To see attachments, please log in.
Testing Applications
System Administration

Posted: 6 years ago
Posted: 3 Jul 2018 4:11 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice