Reserve Queue Item taking inordinate time

Question

PradeepG0495

Member since 2017

11 posts

NJ Courts

Posted: Aug 29, 2017

Last activity: Oct 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

Report

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.

To see attachments, please log in.

Data Integration