Push Performance in a Single-Threaded Environment

The Push of 22,500 UCMDB root CIs (roots in queries) and/or Relationships in a single-threaded environment takes about an hour and is performed in a linear fashion. See the following table.

Performance data in a single-threaded environment
Number of root CIs/CI Relationships Pushed per Hour Multi-Threading Settings in sm.properties
22,500

number.of.concurent.sending.threads=1

min.objects.for.concurent.sending=50

number.of.chunks.per.thread=3

recommended.min.cis.per.chunk=50

To view or edit the sm.properties file in UCMDB, navigate to Data Flow Management > Adapter Management > ServiceManagerEnhancedAdapter9.41 > Configuration Files > sm.properties.

Number of Root CIs and Relationships/22,500

The push time (in hours) in any given environment is calculated as follows:

If the push of a single planned query has the potential of breaching the permitted time frame, the data must be divided into several queries. Each query must be pushed individually.

This query division is performed by creating several queries, each with different node conditions that enable data filtering. Once all queries are pushed for the first time, the Initial Load process is complete.

Note When applying node conditions to the various Service Manager queries, you must make sure that all of the information is included in the queries, so that all relevant data is copied to Service Manager.