Support Article
System performance degrades
SA-55601
Summary
System performance degrades and the following issues occur:
- Log in times are poor
- Screen to screen transition times and persisting rules to the database are long
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
A defect in Pegasystems’ code or rules.
Resolution
Perform the following local-change:
Implement additional database Indexes on standard PegaRULES tables.
CREATE INDEX
RULES.PR_SYS_APP_HIERARCHY_FLT_IDX01
ON
RULES.PR_SYS_APP_HIERARCHY_FLAT
(
PZAPPHEIGHT ASC,
PZAPPHASH ASC,
PZTOPAPPHASH ASC,
PZAPPNAME ASC
);
CREATE INDEX
RULES.PR4_RULE_VW_IDX07
ON
RULES.PR4_RULE_VW
(
PXCOMMITDATETIME ASC,
PXINSID ASC,
PXINSTANCELOCKEDKEY ASC,
PXOBJCLASS ASC,
PYCIRCUMSTANCETYPE ASC,
PYCLASS ASC,
PYCLASSNAME ASC,
PYMETHODSTATUS ASC,
PYRULEAVAILABLE ASC,
PYRULEENDS ASC,
PYRULESET ASC,
PYRULESETVERSION ASC,
PYRULESTARTS ASC,
PZCLASSTYPE ASC,
PZINSKEY ASC,
PZRULESETVERSIONMAJOR ASC,
PZRULESETVERSIONMINOR ASC,
PZRULESETVERSIONPATCH ASC,
PZRULESETVERSIONMINORPATCH ASC
);
CREATE INDEX
DATA.APPMETADATA_IDX02
ON
DATA.PR_DATA_RULE_APPMETADATA
(
PXOBJCLASS ASC,
PYMETADATATYPE ASC,
PYAPPNAME ASC,
PYAPPVERSION ASC
);
CREATE INDEX
RULES.RULES.PR_REFERENCE_PAGE_IDX04
ON
RULES.PR_REFERENCE_PAGE
(
PXINSINDEXEDCLASS ASC,
PXOBJCLASS ASC,
PXPAGENAME ASC,
PXREFERENCINGRULESETNAME ASC,
PXREFERENCINGRULESETVERSION ASC
);
CREATE INDEX
DATA.PC_ASSIGN_WORKBASKET_IDX02
ON
DATA.PC_ASSIGN_WORKBASKET
(
PXASSIGNEDOPERATORID ASC,
PXOBJCLASS ASC,
PXREFOBJECTINSNAME ASC,
PXREFOBJECTKEY ASC,
PXREFQUEUEKEY ASC,
PXREQUIREDSKILLSCOUNT ASC
);
CREATE INDEX
RULES.PR4_RULE_PROP_IDX01
ON
RULES.PR4_RULE_PROPERTY
(
PXINSID ASC,
PXINSNAME ASC,
PXOBJCLASS ASC,
PYCLASSNAME ASC,
PYDATAOBJECT ASC,
PYDATAOBJECTCLASS ASC,
PYPAGECLASS ASC,
PYRULEAVAILABLE ASC,
PYRULESET ASC,
PZINSKEY ASC
);
CREATE UNIQUE INDEX
DATA.PR_DATA_TAG_RELREC_IDX01
ON
DATA.PR_DATA_TAG_RELEVANTRECORD
(
PXOBJCLASS ASC,
PXRECORDINSID ASC,
PXCONTEXTCLASS ASC,
PXRECORDTYPE ASC,
PXISACTIVE ASC
);
CREATE INDEX
RULES.PR4_RULE_DECLAREPG_IDX01
ON
RULES.PR4_RULE_DECLAREPAGES
(
PXINSID ASC,
PXINSNAME ASC,
PXOBJCLASS ASC,
PYCLASSNAME ASC,
PYRULEAVAILABLE ASC,
PYRULENAME ASC,
PYRULESET ASC
);
CREATE INDEX
DATA.PR4_LOG_DETAIL_IDX02
ON
DATA.PR4_LOG_RULE_USAGE_DETAILS
(
PXOBJCLASS ASC,
PXSYSTEMNODE ASC
);
CREATE INDEX
RULES.PR4_FIELDVALUE_IDX03
ON
RULES.PR4_FIELDVALUE
(
PXINSNAME ASC,
PXOBJCLASS ASC,
PYCLASSNAME ASC,
PYFIELDNAME ASC,
PYMETHODSTATUS ASC,
PYRULESET ASC,
PYRULESETVERSION ASC
);
CREATE INDEX
RULES.PR4_BASE_IDX05
ON
RULES.PR4_BASE
(
PYCLASSNAME ASC,
PXOBJCLASS ASC,
PYCATEGORY ASC,
PYMETHODSTATUS ASC
);
CREATE INDEX
RULES.PR_INDEX_REFERENCE_IDX03
ON
RULES.PR_INDEX_REFERENCE
(
PXINSINDEXEDCLASS ASC,
PXOBJCLASS ASC,
PXRULECLASSNAME ASC,
PXRULEOBJCLASS ASC,
PYRULENAME ASC
);
CREATE INDEX
DATA.PR4_LOG_RULE_USAGE_IDX01
ON
DATA.PR4_LOG_RULE_USAGE
(
PXLASTUSE ASC,
PXSYSTEMNODE ASC,
PYLABEL ASC,
PZINSKEY ASC
);
Published August 15, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.