Slow SQL on table RULES.PR4_RULE_PROPERTY

General
, ,
1

Hi,

I am getting below error while service call and it’s causing DB CPU spike, I am on Pega 8.6.2 version, Also Indexing is there in the table.

Database operation took more than the threshold of 500 ms: 28,355 ms SQL: SELECT pyPropertyName AS “pyPropertyName”, pyPageClass AS “pyPageClass”, pyPropertyMode AS “pyPropertyMode” FROM RULES.pr4_rule_property “property” WHERE (pxObjClass = ‘literal’) AND (pyClassName = ?) AND (pyRuleAvailable = ‘literal’)

2

@Ashwin I can see that you logged support ticket INC-261580 at the same time.

Please continue to work with the support team who will need you to provide connector configuration screenshots as well as Collect DB trace when executing the GetQualifiedOfferings service call.

Also could you please check with DBA once on below points:

  1. Update database statistics and rebuild database clustered indexes on all tables involved in query.

  1. Execute database vacuum process.

  2. Perform data defragmentation on database.

Also please perform the steps listed in the following article:

Performance degrades when parsing connect-REST JSON response

3

The support ticket was resolved with the following information:

" Client was using JSON response data transform in the connectors call,. Client evaluated and found they could update the fast processing option in connectors. Issue was no longer occurring. "