BW OLAP Cache Mode 5 – “BLOB/Cluster Enhanced” – Is the recommended cache mode

With Support Package 16, a new cache mode with an optimized architecture was delivered for BW 7.0. This mode explicitly addresses the basic problems that were connected with the existing cache modes 1-4 up to now. In particular, these include cache entries that have been lost or were not assigned and the blocks due to enqueue locks that occur under a high load.
The new mode is managed in BW 7.0x as “BLOB/Cluster Enhanced” under number 5, or in higher versions of BW, with the same number as “Query Aggregate”.
Performance is usually noticeably better for mode 5, and is therefore recommended as the standard for most applications.

See related note – Note 1026944 – New cache mode with no directory for BI 7.0

See help on OLAP Cache Monitor – http://help.sap.com/saphelp_nw70/helpdata/en/41/b987eb1443534ba78a793f4beed9d5/content.htm

See help on  BW Cahce Mode – http://help.sap.com/saphelp_nw70/helpdata/en/d9/31363dc992752de10000000a114084/content.htm

Configuration and Utilization of the  OLAP Cache to Improve the Query Response Time  http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0ebfba1-5a1a-2d10-82b5-fdddc1e5955c?quicklink=index&overridelayout=true

Leave a Reply