Our Performance Center console has slowed down again. Users are reporting hung pages, out of memory errors, and general slowness.
Memory and CPU usage is being used by the Performance Center processes, or MySql
Release : 20.2
To find out which processes are currently running in the MySql database, run the following
/opt/CA/MySql/bin/mysql -uroot -A -e"SHOW FULL PROCESSLIST\G;" > /tmp/PROCESSES.txt
If there is a large query that is hanging up, you can narrow the scope of the view, making it less resource intensive
Run "top" on the Performance Center system, to see how much memory and CPU each process is using
Determine how much memory or heap is being used by the Data Aggregator