000032254 - Aveksa Statistics Report (ASR) workflow history information for RSA Via Lifecycle & Governance (L&G)

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032254
Applies ToRSA Product Set: RSA Via Lifecycle and Governance (L&G)

RSA Version/Condition: 7.0.1, 6.9.1 P10+, 6.8.1 P22+
IssueWorkflow jobs or nodes with a large number of history records have been known to lead to system performance issues such as 100% CPU usage and out of memory errors. 
When Engineering triages such performance issues reported by a customer, it has become common to ask Support to run some SQL queries on the customer environment and provide the results back to Engineering to help determine whether workflow jobs or nodes with large amount of history could be the root cause.
Resolution

In order to reduce this back and forth between Engineering, Support and the customer, we have added those queries to the ASR which is already one of the standard artifacts that are collected for performance issues.



Two additional sections have been added to the Aveksa Statistics Report (ASR) in the Workflow Information section.  These are:


  • Top 10 Workflow Jobs By History – A table containing information about the top ten workflow jobs that have the largest number of history records in the database. Information includes the Job Name, Job ID, Job DB, and History Count; and
  • Top 10 Workflow Nodes By History – A table containing information about the top ten workflow job nodes that have the largest number of history records in the database. Information includes the Node Name, Job ID, Job DB, and History Count.

Attachments

    Outcomes