Use > Database > Introducing the Database Environment > Introduction to Preparing the Database Environment > Large Capacity Planning for UCMDB

Large Capacity Planning for UCMDB

This section includes:

Large Capacity Planning Overview

Using the default configuration, Universal CMDB can work with a deployment of more than 25 million CIs and relationships. To work with a larger deployment, you must implement the following configuration:

Depending in the number of CIs and relationships, increase the CMDB heap as follows:

# CIs and Relationships Heap Size
≤ 40 million 12 GB
40 million – 60 million 16 GB
60 million – 125 million 24 GB
> 125 million 55 GB

  • For capacity planning requirements, see the Support Matrix section of the UCMDB Help.
  • For details about the changes you must make to the system configuration to support this capacity, see "Configuring the UCMDB Server for Large Capacity" in the Deployment Guide.
  • For details on how to improve performance, see "Configuring the Oracle Database for Large Capacity" and "Configuring the Microsoft SQL Database for Large Capacity" in the Deployment Guide.
  • For details about the setup used for capacity testing and performance results, see "System Capacity Test" in the Deployment Guide.

Configuring the UCMDB Server for Large Capacity

For the system to support the desired number of CIs and relationships, update the following parameters on the UCMDB Server:

  Parameter Default CIs and Relationships (million)   Location
≤ 40
 40 – 60
60 – 125 > 125
wrapper.java.
initmemory 		1024 2048 8192
  • Windows: C:\UCMDB\UCMDBServer\bin\wrapper-platform.conf
  • Linux: /opt/UCMDB/UCMDBServer/bin/wrapper-platform.conf
wrapper.java.
maxmemory 		4096 8192 16384 24576 56320
wrapper.java.
additional.31=
-XX:MaxMetas
paceSize 		256 512 1024
dal.object.condi
tion.max.result.
size 		2000000 50000000 50000000
  • Windows: C:\UCMDB\UCMDBServer\conf\
    settings.override.properties
  • Linux: /opt/UCMDB/UCMDBServer/conf/
    settings.override.properties
dal.use.memory.
instead.temp.tab
le.high.threshold.
oracle 		600000 6000000 6000000 10000000
dal.joinf.max.res
ult.size 		400000 4000000 4000000

Configuring the Oracle Database for Large Capacity

When working on a system containing more than 40 million objects and relationships, you can improve performance by increasing the Oracle SGA and PGA to the following suggested sizes:

CIs and Relationships SGA PGA
40 million – 60 million 22 GB 6 GB
60 million – 120 million 42 GB 14 GB
> 120 million 88 GB 24 GB

This improves the performance of both the TQL calculation for several types of TQL queries, as well as for data-in operations performed on the system.

Configuring the Microsoft SQL Database for Large Capacity

When working on a system containing more than 40 million objects and relationships, you can improve performance by increasing the Microsoft SQL Server Memory to the following suggested sizes:

CIs and Relationships Microsoft SQL Server Memory
40 million – 60 million 28 GB
> 60 million 56 GB

Configuring Configuration Manager for Large Capacity

Configuration Manager supports working with up to 20,000 composite CIs in a single managed view. To enable this functionality, do the following:

Note

  • If you want to enable this functionality, it is recommended to install Configuration Manager on a server that has a minimum of 8 GB of memory (RAM).

  • Managed views that are based on dynamic TQL queries and result in more than 20,000 composite CIs are not supported.

  1. To access the JMX console, launch your Web browser and enter the following address: http://<server_name>:<port_number>/cnc/jmx-console, where <server_name> is the name of the machine on which Configuration Manager is installed.

  2. Enter the JMX console authentication credentials.

  3. Click Configuration Manager > View Service. Select supportLargeViews and click Invoke.

  4. In UCMDB, change the value of the TQL Group View Result Size setting to 500,000 (Administration > Infrastructure Settings Manager > TQL Settings).

  5. Do one of the following:

    • If you use the Universal CMDB Configuration Manager Windows service to start Configuration Manager, navigate to the <Configuration_Manager_installation_directory>/bin/ folder and double-click the edit-server-0.bat file. In the Java tab, increase the value of the Maximum memory pool parameter to 4096 or greater.
    • If you use the start-server-0.bat file to start Configuration Manager, edit the start-server-0.bat file and raise the value of the –Xmx parameter to 4096m or greater.

System Capacity Test

Setup

The system capacity test is conducted for Microsoft SQL Server (with 125 million CIs and relationships) and Oracle Database (with 200 million CIs and relationships) separately, by using the following hardware configurations.

 

The following business flows were tested as part of the system test:

  • TQL Calculation

    TQLs were divided into sub groups according to the result size (<100, <1000, and <10000), according to the data set that the TQL retrieves, and according to the TQL configuration:

    • Like Condition
    • Like Ignore case
    • Different number of hierarchies in the TQL results (2-5)
    • Compound
    • Sub-graph

  • Data-in

    The data-in scenario in the system test included insertion, updates, and deletion.

  • Enrichments

    Enrichment scenarios included insert, update, and delete.

Results

Following the load test in the scenario that includes query execution (2 days), data-in (7 days for Oracle and 10 days for MS SQL), and enrichment execution, the following results were achieved:

  • The system was stable throughout the run. No restarts, memory leaks, or any other degradation over time was observed.
  • System performance was acceptable.

Send Help Center feedback