Question

2
Replies
90
Views
PradeepG0495 Member since 2017 11 posts
NJ Courts
Posted: 3 years ago
Last activity: 1 year 11 months ago
Closed
Solved

Reserve Queue Item taking inordinate time

Hi,

We need to process a million records and create cases in Pega. Each case takes around 30-40 seconds. We have designed a parallel batch process with 200 standard agents. Everything is working fine but we observed the below alert very frequently.

MessageDatabase operation took more than the threshold of 8000 ms: 54,986 ms SQL: {call PEGCCDBP.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }

As a result of this, we have realized having 200 agents is not actually helping at all, if not being counter productive. If it takes 54 seconds to reserve a queue item what is the purpose of having 200 agents. Any advise??

Thanks,

Pradeep

***Edited by Moderator Marissa to update categories & to add SR Details***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Data Integration SR Parallel
Moderation Team has archived post
Share this page LinkedIn