Description
Slow queries from job "Error Manager - Update Counters".
Release or Environment
All currently supported environments.
Cause
The "Error Manager - Update Counters" updates the values in "Discovery > Home" and "Discovery > Home > Schedules" (errors per schedule). It runs queries on automation_error_msg and updates automation_error_code_stats. The queries can take longer as the automation_error_msg table grows.
Resolution
- Lower the frequency of the "Error Manager - Update Counters" job to once every hour or even once every day (this will depend on how often these pages are used).