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

  • 7006546
  • 02-Aug-2010
  • 11-Jul-2012

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>