sppr_sys_reservequeueitem_b
We recently upgraded from PRPC 7.2.1 to 8.5.2. Our DB folks have indicated that since the upgrade the sppr_sys_reservequeueitem_b, making a select call to pr_sys_queues, is executing millions of times per day resulting in very high cpu usage. What controls how often this proc is called related to pr_sys_queues?
Pegasystems Inc.
IN
Updated: 18 Aug 2021 14:28 EDT
Ameriprise Financial
US
@SuhasKumar Thank you for the reply. Yes, it is an Oracle environment. Can you help me understand how altering the orderby affects the number of times the proc/query would be executed?
In looking at the information from our db team, it appears that the orderby is already in the form that you suggest
Pegasystems Inc.
IN
@MarkH960 sppr_sys_reservequeueitem_b supports asynchronous execution of agents.
Can you stop all the custom agents and allow/run only OOTB agents. It should stop the "millions of times per day" execution.
@MarkH960 what is the database type?
If this is an ORACLE environment. can you try to alter the ORDER BY clause of the standard stored procedure sppr_sys_reservequeueitem_b:
FROM:
orderby := ' order by pzInsKey ASC';
TO:
orderby := ' order by pyMinimumDateTimeForProcessing ASC';