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

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

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

More offers in SAP Cloud Appliance Library for Azure

As you might already know, SAP has an offer called SAP Cloud Appliance Library (SAP CAL – http://cal.sap.com ). SAP CAL offers you to deploy pre-configured software appliances on different public clouds, Azure being one of those public clouds. Advantages of SAP CAL are that you have an easy way to deploy and test these… Read more

SAP on SQL: General Update for Customers & Partners June 2016

Introduction SAP and Microsoft are continuously adding new features and functionalities to the SAP on SQL Server platform. The key objective of the SAP on Windows SQL port is to deliver the best performance and availability at the lowest TCO. This blog includes updates, fixes, enhancements and best practice recommendations collated over recent months. 1…. Read more

SAP MaxDB, SAP liveCache and SAP Content Server are certified to run in Microsoft Azure Cloud

We are pleased to announce certification and support for the three new SAP products on Microsoft Azure cloud: SAP MaxDB database SAP liveCache SAP Content Server   SAP MaxDB Database SAP MaxDB is one of the three databases owned by SAP. You can use the SAP MaxDB database in different context, for example as standalone… 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

Columnstore Optimized Flat Cube in SAP BW

With the general availability of SQL Server 2014, a new feature was released in SAP BW: The Columnstore Optimized Flat Cube. The prerequisites for the Flat Cube are described in in SAP Note 2114876 and in the following blog: http://blogs.msdn.com/b/saponsqlserver/archive/2015/01/08/sql-server-column-store-for-sap-bw-status-and-release-planning.aspx. The Columnstore Optimized Flat Cube is an alternative cube design, which is available as of… Read more