Highlighted
Super Contributor.. Super Contributor..
Super Contributor..
509 views

RTSM/ucmdb view performance slow

Hi

 

Hope to seek some advice on improving execution performance on views in RTSM (OMi 10.01).

 

We have a view returning thousands of CIs,which takes a considerable amount of time to execute. The following jmx statistics show,

Mbean: UCMDB:service=New Views Services. Method: viewStatistics[java.lang.Integer|java.lang.String]

View execution for "ASTRO25 Infrastructure" took:

Execute: 11312[ms]

Traversal: 5144[ms]

Total: 16456[ms]

 

View result:

Total nodes (CI/Groups): 38839 (38839/0)

Layers (leaves): 2220(36620)

Topology result:

CIs: 38839

Relations: 38838

 

The view consistently takes 17-20 seconds to execute. We require all the CIs to be returned in this view. Are there ways we can improve this performance? I've tried various configurations on the Query to no avail. We have more server memory capacity if adjusting some backend memory parameters help.

 

Cheers

Mick

0 Likes
2 Replies
Highlighted
Super Contributor.
Super Contributor.

Hello,

There are two main optimization areas. First, you should increase memory for RTSM. For example you cound increase size of model in configuration wizard to "Large", or manually increase Xmx parameter. Second, RTSM performance heavily relies on DB performance. You should take closer look at your database. You could use statistics from cmdb.dal.log (located on BSM DPS server) to see queries.

 

regards

Grzegorz Kluczek

uCMDB ASE Expert

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Suppose you are talking about an on-premise environment. What about a SAAS solution ? Which area's should be touched in order to finetune performance ?

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.