Slow SQL on table RULES.PR4_RULE_PROPERTY
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')
***Edited by Moderator Marije to add Support Case Details; update capability tags***
Accepted Solution
Pegasystems Inc.
GB
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. "
Updated: 27 Feb 2023 8:38 EST
Pegasystems Inc.
GB
@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.
2. Execute database vacuum process.
3. Perform data defragmentation on database.
Also please perform the steps listed in the following article:
Performance degrades when parsing connect-REST JSON response
Accepted Solution
Pegasystems Inc.
GB
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. "