Highlighted
toomas_aas Absent Member.
Absent Member.
702 views

CMDB import performance

We are trying out import of CMDB data from ZCM 11.3 to NSD 7.0.3 appliance. Our ZCM database contains approximately 700 workstations.

We set up AMIE with Server Type as "ZENworks Configuration Management v11.1" and set schedule to Daily. Having observed the system a few days, it seems that the import job does not complete in 24 hours and the next one starts before the previous has finished. I restarted Tomcat on the NSD appliance and changed the schedule to Weekly. The import job has now been running for 48 hours and is still not complete. CPU on the NSD appliance is constantly at 100%. Top shows that the busiest process is postgres. The database seems to be busy processing queries such as this:

select count(*) as col_0_0_ from ITEM_HISTORY itemhistor0_ cross join ITEM_SNAPSHOT itemsnapsh1_ where itemhistor0_.SNAP_ID=itemsnapsh1_.ID and itemhistor0_.ASSET_ID=$1 and (itemsnapsh1_.INCIDENT_ID is null)


I'm not familiar enough with NSD to understand what this query is trying to do. I wonder if we are doing something unreasonable, or is it normal for the import to be this slow.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.