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

SAP OS/DB Migration to SQL Server–FAQ v6.2 April 2017

The FAQ document attached to this blog is the cumulative knowledge gained from hundreds of customers that have moved off UNIX/Oracle and DB2 to Windows and SQL Server in recent years. In this document a large number of recommendations, tools, tips and common errors are documented.  It is recommended to read this document before performing… Read more

SAP on Azure: General Update for Customers & Partners April 2017

SAP and Microsoft are continuously adding new features and functionalities to the Azure cloud platform. The objective of the Azure cloud platform is to provide the same performance, product availability support matrix and availability as on-premises solutions with the added flexibility of cloud. This blog includes updates, fixes, enhancements and best practice recommendations collated over… Read more

Transparent Data Encryption (TDE) acceleration for SQL 2016 in Windows Azure

Today we want to show you the speed improvements we get by supporting the Intel AES-NI instruction set for transparent data encryption (TDE) on Windows Azure. This instruction set reduces the CPU overhead of turning on Transparent Data Encryption for SQL Server databases. For the testing scenario we used an Azure DS15 virtual machine with… 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

SAP on SQL: General Update for Customers & Partners March 2017

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 and simplest operation. This blog includes updates, fixes, enhancements and best practice recommendations collated over recent… 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

SAP Business Objects support of SQL Server 2016 and Azure products

These days, we get a lot of questions around SAP Business Objects components supporting SQL Server 2016. As of February 2017, the support situation looks like: SAP BusinessObjects BI Platform 4.1: As of SAP BusinessObjects BI Platform 4.1 SP09, SAP introduced support for SQL Server 2016 which got released for SAP NetWeaver in 2016 already… Read more