Posted: 2 Nov 2017 12:52 EDT Last activity: 24 Nov 2017 10:35 EST
Select query for pr4_rule_library table is running more frequently
We are getting below alert many times in the logs. Not sure if it is common. We are seeing over 800 times on each node.
Alert: Database operation took more than the threshold of 500 ms: 653 msSQL: select pzPVStream , pxCommitDateTime from PEGA_RULES.pr4_rule_library where "PYLIBRARYNAME" = ? and "PYRULESET" = ? and pxObjClass = ? order by "PYDECORATEDFUNCTIONNAME" , "PYRULESETVERSION" , pzInsKey
The query seems to be related with PRPC trying to fetch information for RULE-UTILITY-FUNCTION(RUF) frequently. You can use DB trace to understand corresponding to which scenario the query gets generated frequently.
But the query just marginally breaches the threshold of 500 ms and should not be worrying factor.