|Applies To||RSA Product Set: RSA Via Lifecycle and Governance (L&G)|
RSA Version/Condition: 7.0.1, 6.9.1 P10+, 6.8.1 P22+
|Issue||Workflow 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.
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.