Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Arjan Maus (ArjanM04) Achmea
Achmea
NL
ArjanM04 Member since 2014 48 posts
Achmea
Posted: Dec 4, 2017
Last activity: Dec 18, 2017
Posted: 4 Dec 2017 6:44 EST
Last activity: 18 Dec 2017 2:52 EST
Closed
Solved

spprsysreservequeueitemb-stored-procedure-taking-more-time

Hi all,

We are getting messages within our PGA Rules Alert log files that above mentioned query is getting slower.

I stumbled upon below URL, but it states that this is applicable to ORACLE.

Is this also usefull in DB2?

Best, regards,

Arjan Maus

https://collaborate.pega.com/question/spprsysreservequeueitemb-stored-procedure-taking-more-time

***Edited by moderator, Maryrita: moved to Product Support from PegaBuzz***

To see attachments, please log in.
Data Integration System Administration

Accepted Solution

Posted: 6 years ago
Posted: 5 Dec 2017 3:22 EST
Ujjwal Kumar Shukla (UjjwalShukla_GCS) PEGA Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi Arjan,

Default threshold is 500ms I think for sql operation.

We have seen that this threshold generally overshoots by meager values(500ms to 100ms) range.
If such is the case you may ignore it or get in touch of DBA for further analysis.

The post that you have referred to mentions the tuning specific to stored proc in Oracle and same may be applicable at your end.

Open the stored proc and apply it if you find Stored proc with similar code as that of mentioned in that post.

Thanks,
Ujjwal

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice