Highlighted
enriquelobo33 Regular Contributor.
Regular Contributor.
365 views

(SM) Support Tip: Tip for speeding up uCMDB Population jobs from Service Manager

Hello team,

   A few days back, I worked on an situation where a POPULATION job was taken around 7-10 seconds per CI, on a real life situations where there can be thousands of Cis, this can make this job a time demanding action taking often hours or evens several days to do a full sync.

   Since we are dealing with a POPULATION job, we could avoid some actions in SM that consumes most time. In our case, most of the time was being spent when validating the cascade updates, OOB it will perform queries on contractitem, SYSATTACHMENTS, two on cirelationships (one looking for parents, other for childs) and cigroup.

  Usually, for SM normal operations these cascade updates are useful to maintain data integrity, however on a POPULATION job this is not likely to be used.

   The reason these are called by on a POPULATION job is because once a new CI is inserted in uCMDB from SM, the CMDB engine will execute a push back update action to fill the new ucmdb.id field on the device, however this request (UpdateucmdbIDPushBackRequest) will only modify this field, so in theory no other action will ever take place and the cascade updates will never update related records, however they WILL perform the query adding valued seconds to the processing.

   This can be easily bypass if we use a condition on the cascadeupdate record using the integration operator (in the example is falcon).

   You could eventually create a different cascade update record and match the conditions so that only the custom one will execute on the integration jobs.

cascadeupd.jpg

   After doing this change, we notice that each CI went from taking 6-10 seconds to process around 20 per second.

Cheers,

Enrique Lobo.

Labels (1)
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.