OOTB Pega Query fetching data from pr_sys_queues running too many times each hour
Hi,
Below Pega OOTB query is executing multiple thousand of times within an hour in Pega PRPC V8.5.2
We started seeing this issue after we upgraded our application from v7.2 to v8.5.2
select pzinskey from (select pzinskey from spegad1.pr_sys_queues where pyitemstatus=:1 and pyagentname=:2 and pyminimumdatetimeforprocessing<=:3 order by pyminimumdatetimeforprocessing asc)
I found similar issue reported on below link but article is for older version of pega
High SQL query execution causes poor database performance | Pega If anyone aware how to fix this issue, please let me know. Thanks in advance!
Ford Motor Company
US
@VIKASHP3 pr_sys_queues will be used in backgroundprocessing tasks, make sure you stopped/cleaned up Agent Schedules in the given environment, so that particular jvm won't run unnecessary agents which causes the overhead to the sys queue tables.
Ideally, all agesnt must be disabled at Agent Rule and enable only in the appropriate JVMs using Agent Scheduled and if possible move to latest alternatives like Queue Processors or Job Scheduers.
Ameriprise Financial
IN
@SUMAN_GUMUDAVELLY Thanks for your suggestion! We are reviewing running agents and see disabling unnecessary one helps in resolving issue.