Jeremy Rochon (JeremyR4)
Segue Technologies Inc

Segue Technologies Inc
JeremyR4 Member since 2019 14 posts
Segue Technologies Inc
Posted: October 31, 2019
Last activity: October 31, 2019
Posted: 31 Oct 2019 9:08 EDT
Last activity: 31 Oct 2019 9:53 EDT

Agile Studio Import Slowness Question


I installed a Pega Platform 8.1 instance a few months back with Agile Studio and while doing the import for Agile studio it took a deathly amount of hours to finish. This instance was configured with Tomcat Apache 8 & Sql Server DB. Recently one of my colleagues performed the same import for another Pega 8.3 instance which utilizes Tomcat Apache 8 & Oracle DB. In the catalina logs he was able to locate some errors which pointed to an attribute/value named MaxOpenCursors which was set to around 60 but once he ran the following command: ALTER SYSTEM SET open_cursors = 800 SCOPE=BOTH; He noticed the import sped up intensely. So I did some digging in the logs from when I initially created the 8.1 instance but found no such attribute/value or any errors even remotely close.

I am wondering if anyone has any idea on if there is a similar attribute/value which can be configured to speed up the Agile studio import for Sql Server? Or anything that can be configured to accelerate the import process?

Thank you.

Pega Platform
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.