Flat Cube became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Flat-Cube-became-default-in-SAP-BW/ba-p/368151 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 Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP… Read more

Columnstore became default in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Columnstore-became-default-in-SAP-BW/ba-p/368149 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 Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP… Read more

Improve SAP BW Performance by Applying the Flat Cube

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Improve-SAP-BW-Performance-by-Applying-the-Flat-Cube/ba-p/368125 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 Overview SAP released the Columnstore Optimized Flat Cube over two years ago. We want to give a brief explanation of the benefits and advantages of using the Flat… Read more

Customer Experience with Columnstore on ERP

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Customer-Experience-with-Columnstore-on-ERP/ba-p/368118 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 SAP released the report MSS_CS_CREATE a few months ago. Using this report, customers can create an additional Nonclustered Columnstore Index (NCCI) on any SAP ERP table. This… Read more

New SQL Server 2016 functionality helps SAP supportability

Due to the combined effort of the SAP – Microsoft Porting group the SQL Server Development team added a new functionality to the SQL Server UPDATE STATISTICS command and to the way SQL Server automatically updates statistics. This new functionality enables the SAP customers on SQL Server to persist a sample rate of the manual… Read more

Customer experience with SAP BW FEMS-Pushdown

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Customer-experience-with-SAP-BW-FEMS-Pushdown/ba-p/368084 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 A few months ago we released a new SAP BW statement generator, which increases BW query performance for complex queries containing FEMS filters, see https://blogs.msdn.microsoft.com/saponsqlserver/2017/03/06/bw-queries-by-factors-faster-using-fems-pushdown. In the… Read more

Parallel Processing in SAP

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Parallel-Processing-in-SAP/ba-p/368079 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 New generations of CPUs do not provide any significant single-thread performance improvements. Instead, the number of logical CPU cores is increasing with each new CPU generation. You… Read more

Performance evolution of SAP BW on SQL Server

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Performance-evolution-of-SAP-BW-on-SQL-Server/ba-p/368073 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 In SAP customer support, we still see several customers running old SAP BW code that cannot leverage the improvements we delivered within the last years. In this… Read more

Using Columnstore on ERP tables

SQL Server columnstore indexes are optimized for aggregations of large amounts of data. Therefore, they are successfully used in SAP’s data warehouse system SAP BW since years. ERP systems typically still use rowstore (b-tree) indexes, because they are optimized for the most common data access pattern of ERP systems: Directly reading a few rows specified… Read more

More Questions From Customers About SQL Server Transparent Data Encryption – TDE + Azure Key Vault

Recently many customers have been moving from AIX and HPUX to Windows 2016 & SQL Server 2016 running on Azure as these UNIX platforms are no longer mainstream, developed or invested by their vendors Most of these customers are deploying TDE to protect the Database files and backups. Encrypting databases with strong ciphers like AES-256… Read more