Environment
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>