OOTB Pega Query fetching data from pr_sys_queues running too many times each hour
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!