Storage tuning

Storage is the second major area for tuning. If the number of sensors in the storing stage is approximately the value of the property that specifies the number of parallel storage threads, storage of the discovery results is causing the performance bottleneck. To improve performance, you can also limit the number of threads that are responsible for storing data.

The following property specifies the number of parallel storage threads. It is one of the main settings for controlling the discovery storage performance:
com.collation.discover.observer.topopumpcount

To improve storage performance when the topology agents are running, you can limit the number of threads that are responsible for storing data during a discovery. As a result, a discovery takes less time to complete. To specify the limit of threads that are running, edit the following properties in the collation.properties file:

com.ibm.cdb.discover.observer.topopump.threshold
This property specifies the number of storage threads to limit.
com.ibm.cdb.discover.observer.topopump.threshold.<agentGroupName>
This property specifies the number of storage threads to limit when the specified agent group is running.

The following table shows how much the com.ibm.cdb.discover.observer.topopump.threshold property can improve the discovery performance. The calculations concern a database with 76 000 configuration items.

Threshold property value Percentage time improvement
0.2 55
0.5 33
0.7 13
1 0