- 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 https://launchpad.support.sap.com/#/notes/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:
- https://support.microsoft.com/en-us/kb/3067839 .
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 https://service.sap.com/sap/support/notes/2153188 for details
- BW cube compression of the Flat Cube is much faster:
See https://service.sap.com/sap/support/notes/2153188 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 https://service.sap.com/sap/support/notes/2116639 , which always contains the latest news regarding SQL Server Columnstore on SAP BW.
Updated May 10, 2019
Version 4.0