BSLM query takes too much time: maxNodes, maxAgeSeconds and timeToLiveSeconds

  • Document ID:7006546
  • Creation Date:02-Aug-2010
  • Modified Date:11-Jul-2012
    • Micro Focus Products:
      Operations Center

Environment

Business Service Level Management 4.5
Business Service Level Management 4.6
Business Service Level Management 4.7

Situation

SLA or BSLM query taking too much time to return. It appears that we are hitting the database often and external query time is

very high for some queries.

Resolution

Increase the number of cache maxnodes, AgeSeconds and timeToLiveSeconds in

<MOInstall>/config/bslmcache.xml

from:

 <!-- Query Cache -->

              <region name="/bslm/query/cache">

                  <attribute name="maxNodes">50000</attribute>

                  <attribute name="maxAgeSeconds">180</attribute>

                  <attribute name="timeToLiveSeconds">180</attribute>

              </region>

to:

<!-- Query Cache -->

              <region name="/bslm/query/cache">

                  <attribute name="maxNodes">5000000</attribute>

                  <attribute name="maxAgeSeconds">600</attribute>

                  <attribute name="timeToLiveSeconds">600</attribute>

              </region>