- First published on MSDN on Jun 29, 2015 by Martin Merdes.
- This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html and in SAP Note 2116639
- The performance impact of SQL Server Columnstore is described in https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073
This week we increased the minimum required SQL Server 2014 patch for using the Columnstore with SAP BW. You should upgrade to:
As a matter of course you might apply any newer SQL Server Patch instead. You can always download the latest SQL Server patches from: http://technet.microsoft.com/en-us/sqlserver/ff803383.aspx .
SQL Server 2014 SP1 CU1 solves particularly the following issues:
- Sporadic issues with SQL error 35377 do not occur any more.
See SAP Note 2153188 - SQL Error 35377 for details
- BW cube compression of the Flat Cube is much faster:
See SAP Note 2153188 - SQL Error 35377 for details
- A potential issue regarding a physical inconsistency is fixed.
See https://support.microsoft.com/en-us/kb/3067257 for details. Although we have never seen this issue on an SAP system yet, we strongly recommend applying the SQL Server patch above.
We have updated SAP Note 2116639 - SQL Server 2014 Columnstore documentation , which always contains the latest news regarding SQL Server Columnstore on SAP BW.
Updated May 10, 2019
Version 4.0AzureCAT
Microsoft
Joined December 21, 2018
Running SAP Applications on the Microsoft Platform
Follow this blog board to get notified when there's new activity