High CPU Utilization when working with large quantities of versions
Article ID: 135340
CA Harvest Software Change ManagerCA Harvest Software Change Manager - OpenMake Meister
We have a project with thousands of items in it. When trying to do a delete version of a removed folder (where multiple subitems exist), Harvest goes into an unresponsive state and we see very high CPU utilization on AWS RDS.
We can mimic this in QA by simply querying for package contents in a package with over 1000 items. I executed "find version" for items against a project with a large quantity of items, and we get an unresponsive Harvest and RDS goes into a high CPU utilization state.
As of now, I cannot delete or successfully query packages in projects with very large quantities of files.
RDS is set for General Purpose SSD, db.t2.medium instance, and IOPS disabled. Oracle 18.104.22.168.v15
Release : 13.0.3
Component : CA HARVEST SCM CORE FUNCTIONALITY/PROCESS AUTOMATION
We found that statistics were being collected on the Harvest "Temp" tables. This is not recommended since those are meant to be "scratch-pad" space which is constantly being filled and emptied, and filled again. Recommended dropping the statistics option on the temp tables.
Locking the Oracle temp tables so that stats could not be collected resolved the problem.