RTSM/ucmdb view performance slow
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:
Total nodes (CI/Groups): 38839 (38839/0)
Layers (leaves): 2220(36620)
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.
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.
uCMDB ASE Expert