Support Article
Schema import on MSSQL instance slows performance (Tomcat 8)
SA-36315
Summary
Users report that the Schema import on an MSSQL instance is taking unusually longer than expected and sometime the system itself hangs.
No errors appear in the logs and a restart of the instance also did not help.
The application server is Tomcat 8.
Error Messages
Not Applicable
Steps to Reproduce
- Log in to the application.
- Go to Designer Studio >Application >Distribution >Import. Click Next.
- Select PegaFSIFSampleData_Schema_07.22.zip and click Next.
Root Cause
A defect or configuration issue in the operating environment
The schema import caused more thread creation, which the Tomcat 8 application server configuration does not support.
For the Tomcat 8 application server, some parameters have been changed, for example, maxActive changed to maxTotal and maxWait changed to maxWaitMillis.
Resolution
Perform the following local-change:
Set the Tomcat 8 parameters maxTotal and maxWaitMillis to some higher values to support the creation of additional threads during schema import.
Published September 7, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.