Schema import on MSSQL instance slows performance (Tomcat 8)
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.
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.
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.
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 April 11, 2017 - Updated September 7, 2017