Support Article
AES server performance degrades and agents do not respond
SA-89791
Summary
Autonomic Event Services (AES) server performance degrades and the agents do not respond.
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
A defect or configuration issue in the operating environment.
The regular cleanup of the AES tables did not complete and entries that were more than four months old were present.
Resolution
Perform the following local-change:
- Install the SQL server hotfixes to force the database to use the hint provided for better query performance.
Apply the below hotfixes:
a. HFix-48252
b. HFix-44396Create the following Dynamic System Settings (DSS) to use the performance improvements:
Purpose: reporting/useForceOrderHint
Ruleset: Pega-RULES
Value: truePurpose: reporting/useForceOrderHintForRRandAC
Rulset: Pega-RULES
Value: truePurpose: reporting/useMergeHintForRRquery
Ruleset: Pega-Reporting
Value: truePurpose: racache/useForceOrderHintForInvalidationQuery
Rulset: Pega-RULES
Value: true - Clean out the expired data from the tables.
delete from dbo.pegaam_alert where GeneratedDateTime < DATEADD(DAY,-15,GETDATE())
delete from dbo.pegaam_exception where GeneratedDateTime < DATEADD(DAY,-15,GETDATE())
delete from dbo.pegaam_perf_stats where pxSnapshotTime < DATEADD(DAY,-31,GETDATE())
delete from dbo.pegaam_node_stats where SnapshotTime < DATEADD(DAY,-15,GETDATE())
delete from dbo.pegaam_ind_change where pxCreateDateTime < DATEADD(DAY,-15,GETDATE())
delete from dbo.pegaam_crit_event where EventDateTime < DATEADD(DAY,-15,GETDATE())
delete from dbo.pegaam_node_health where pxCreateDateTime < DATEADD(DAY,-2,GETDATE())
delete from dbo.pegaam_indicator where pxCreateDateTime < DATEADD(DAY,-2,GETDATE())
delete from dbo.pegaam_topoffenders where pxCreateDateTime < DATEADD(DAY,-31,GETDATE())
- Confirm that all the PegaAES agents are running.
Published December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.