The following features have been optionally available in SAP BW on Microsoft SQL Server for several years:
The impact of these features is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-.... Customer experience showed, that using these features almost always resulted in BW query performance improvements. Therefore, these features are turned on by default after applying SAP Note 2582158 - Make Columnstore and Flat Cube default .
Columnstore became default only on SQL Server 2016 and newer:
A new cube will be automatically created as a Columnstore Cube, except in the following cases:
A cube is automatically converted to Columnstore (on the target system), if it is empty (on the target system).
There are 3 different ways for converting all cubes to Columnstore. In the second tab of report MSSCSTORE, you can define a global setting for all SAP BW cubes. We aware, that this is a global setting for all (existing and future) cubes, not just a default for new cubes.
When choosing "Always Column Store (CS)" and pressing F8, all cubes are defined in SAP BW as Columnstore Cubes. However, the Columnstore Indexes are not created on the database yet. Report MSSCSTORE should finish within a few minutes, since only the cube definition is changed.
For SAP BW releases below 7.40 SP8 you should convert all BW cubes to Columnstore. For newer SAP BW releases you should consider applying the Flat Cube. A Flat Cube always uses the Columnstore.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.