Error Message :
The Automation Engine system performance slows down when processing several Hostgroup (HOSTG) objects.
Long running DB critical calls on 'Waiting for the host of an agent group' cause the WPs to be at 100% utilization.
A review of the WP logs contain the following:
Root Cause: The checkwait (CHCKWAIT) for an agent is sending a CHK_HG for all agent groups. If 100 agents are started at the same time, all will serialize on the SELECT for UPDATE on EH with 1688.
Release: AUTWAB99000-12.0-Automic Workload Automation-Base Edition
Update to a fix version listed below or a newer version, if available, where the performance has been improved with processing agents in HOSTG objects.
Fix Status: Fixed
Component(s): AE Server and Initialdata
Automation Engine 12.2.0 - Available
Automation Engine 12.1.1 - Available
Automation Engine 12.0.4 - Available
1. Have the DBA run the SELECT statement against the database directly: