Question

2
Replies
25
Views
JeremyR4 Member since 2019 14 posts
Segue Technologies Inc
Posted: 10 months ago
Last activity: 10 months 3 weeks ago

Agile Studio Import Slowness Question

Hello,

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
Share this page LinkedIn