Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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: 
  1. 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-44396 

    Create the following Dynamic System Settings (DSS) to use the performance improvements:

    Purpose: reporting/useForceOrderHint 
    Ruleset: Pega-RULES 
    Value: true 

    Purpose: reporting/useForceOrderHintForRRandAC 
    Rulset: Pega-RULES 
    Value: true 

    Purpose: reporting/useMergeHintForRRquery 
    Ruleset: Pega-Reporting 
    Value: true 

    Purpose: racache/useForceOrderHintForInvalidationQuery
    Rulset: Pega-RULES 
    Value: true 

  2. 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())

     
  3. Confirm that all the PegaAES agents are running.
Suggest Edit

Published December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us