Slow application response after upgrade to Pega 7.1.8
User applications are migrated from PRPC 5.5 SP1 to Pega 7.1.8 and after this upgrade, the application servers were responding slow and user had to restart the application server manually.
No error on screen.
Steps to Reproduce
Access the application to reproduce the issue.
SendStringParametersAsUnicode JDBC connection property was set as false in the user’s environment.
MS SQL JDBC drivers specify a configuration property called sendStringParametersAsUnicode which helps in getting rid of this unicode conversion. This property defaults to 'true’ which makes the driver send every string in Unicode format to the database by default. If the database tables use only the ASCII data types, user MUST disable this property to ensure the following:
1) All parameters of the JDBC statements are sent to the database in ASCII format thereby getting rid of Unicode conversion overhead.
2) All indexes are actively used during data fetches thereby getting rid of whole table scans.
To disable this property, just append the property with its value as 'false' to the jdbc connection URL as shown below:
Set JDBC connection property SendStringParametersAsUnicode to false to improve the performance.