Question

2
Replies
110
Views
Pradeep Gunda (PradeepG0495)
NJ Courts

NJ Courts
US
PradeepG0495 Member since 2017 11 posts
NJ Courts
Posted: August 29, 2017
Last activity: October 4, 2018
Posted: 29 Aug 2017 14:55 EDT
Last activity: 4 Oct 2018 6:52 EDT
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.

Message Database 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 Support Case Parallel
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.