Question

1
Replies
76
Views
Close popover
Raghu Narla (RaghuN99)
ProCom Consulting

ProCom Consulting
US
RaghuN99 Member since 2020 1 post
ProCom Consulting
Posted: August 6, 2020
Last activity: August 7, 2020

Slow stored procedure PEGADATA.SPPR_SYS_RESERVEQUEUEITEM_B

After the PEGA Upgrade to 8.3.1 we are seeing the DB Time exceptions in PDC. Description: 

Slow stored procedure PEGADATA.SPPR_SYS_RESERVEQUEUEITEM_B.

SQL Statement

CALL PEGADATA.sppr_sys_reservequeueitem_b (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  

Rules Causing this Behavior
Rule Type Rule-Obj-Activity Total Time 56 s
Occurrences 1    
       
Class Name SYSTEM-QUEUE-EXECUTIONREQUEST-
Activity Name PROCESSQUEUE
Activity Step # 1

 

I was looking at the article:

https://community.pega.com/support/support-articles/spprsysreservequeueitemb-stored-procedure-taking-more-time

The changes mentioned in the article are already available in the procedure.

Any ideas? Did anyone face this issue after 8.3.1 upgrade?

Pega Platform 8.3.1 Communications and Media