Parallel Processing in SAP

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 can significantly reduce the runtime of a task by running sub-tasks in parallel on many CPU cores. However, splitting a task into sub-tasks consumes additional resources (CPU and… Read more

Performance evolution of SAP BW on SQL Server

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 blog, we want to demonstrate the huge performance improvements which can be achieved even without hardware replacements. Until 2011, the standard configuration of BW queries on SQL Server… Read more

Large Australian Energy Company Modernizes SAP Applications & Moves to Azure Public Cloud

This blog is a technical overview of a project recently completed by a large Australian Energy Company (the Company) over the past 12 months to transform the Company’s SAP Solution from an End of Life HPUX/Oracle platform to a modern SQL Server 2016 solution running on the Azure Public Cloud. This blog focuses on the… Read more

BW Queries by factors faster using FEMS-pushdown

Complex SAP BW queries often contain FEMS-filters. These filters used to be applied on the SAP application server, which was not very efficient. A new SQL statement generator in SAP BW implements an optimized algorithm for FEMS processing. We have seen performance improvements up-to factor 100. The actual performance improvement varies heavily for different BW… Read more

Recent SAP BW improvements for SQL Server

Over the course of the last few months we implemented several improvements in SAP BW. We already blogged about two improvements separately: https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/14/simplified-and-faster-sap-bw-process-chains https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/25/improved-sap-compression-tool-msscompress In this blog we want to describe a few, additional improvements BW query performance of F4-Help Some BW queries were not using intra-query parallelism, because the BW statement generator did not… Read more

Improved SAP compression tool MSSCOMPRESS

SAP program MSSCOMPRESS is a tool for reducing disk space usage of SAP NetWeaver based systems. In addition, it is often used as a monitoring tool. MSSCOMPRESS has been released by SAP over 6 years ago. In the meanwhile, several improvements have been implemented. The latest version of MSSCOMPRESS is available as an attachment of… Read more

Simplified and faster SAP BW Process Chains

Based on customer feedback over the course of the last 12 months we implemented several improvements in SAP BW. The code changes improve SAP platform migrations of very large SAP BW instances from other DBMS to SQL Server significantly. Furthermore, they simplify and accelerate SAP BW process chains for very large BW systems. The most… Read more

SQL Server 2016 improvements for SAP (BW)

SAP recently released support for SQL Server 2016 for some SAP NetWeaver based systems, see https://blogs.msdn.microsoft.com/saponsqlserver/2016/10/04/software-logistics-on-sql-server-2016. SQL Server 2016 contains many new features which can be used by SAP. For SAP BW, particularly the improved columnstore features are relevant. An overview of SQL Server Columnstore in SQL Server 2014 is published here: https://blogs.msdn.microsoft.com/saponsqlserver/2015/03/24/concepts-of-sql-server-2014-columnstore. The most… Read more

Improvements of SAP (BW) System Copy

For performing an r3load-based system copy of an SAP system you should use the SAP Software Provisioning Manager (SWPM). For a BW system it is mandatory to run the report SMIGR_CREATE_DDL before the system copy and RS_BW_POST_MIGRATION after the system copy. Both reports have been improved with the new SAP BW code delivered for SQL… Read more

Required SQL Server patch for Columnstore

This week we increased the minimum required SQL Server 2014 patch for using the Columnstore with SAP BW. You should upgrade to: SQL Server 2014 SP1 Cumulative Update 1. 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… Read more