SAPS ratings on Azure VMs – where to look and where you can get confused

Moving SAP software to Azure, you need to decide which Azure VM types you want to use. One of the major criteria for selecting a certain VM is the throughput requirement of the SAP workload. SAP decided decades ago, to characterize the throughput in SAPS (SAP Application Performance Standard). To measure the SAPS a server… Read more

SAP on SQL Server on Azure – How to Bypass Proxy Server During Backup to URL

This short blog discusses how to avoid overloading an on-premises or Azure Proxy server with Backup to URL. Creating a typical .Net configuration file to disable a proxy server will allow BackupToURL.exe to communicate via https directly to Azure blog storage. 1. SQL Server Backup to URL Modern releases of SQL Server support backups to… Read more

Installation and Setup of Oracle 12.2 ASM on Oracle Linux on Azure – Installation Videos & Backup Strategies

This short blog contains videos showing the end to end installation process to setup Oracle 12.2 ASM on Azure. The videos and documentation in this blog are being used to get formal certification for Oracle 12.2 ASM on Azure. This process is still ongoing It is important to follow the procedure documented in this blog… Read more

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

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