Setting Up Hana System Replication on Azure Hana Large Instances

This blog details a recent customer deployment by Cognizant SAP Cloud team  on HANA Large Instances. From an architecture perspective of HANA Large Instances, the usage of HANA System Replication as disaster recovery functionality between two HANA Large Instance units in two different Azure regions does not work. Reason is that the network architecture applied… Read more

SAP on SQL Server: General Update – January 2018

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

SAP on Azure: General Update – January 2018

SAP and Microsoft are continuously adding new features and functionalities to the Azure cloud platform. This blog includes updates, fixes, enhancements and best practice recommendations collated over recent months. 1. M-Series, Dv3 & Ev3-Series VMs Now Certified for NetWeaver Three new VM types are certified and supported by SAP for NetWeaver AnyDB workloads. AnyDB refers… Read more

Improve SAP BW Performance by Applying the Flat Cube

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 Cube – and in consequence engage customers to apply it. The Flat Cube has many benefits, for example, improved BW query performance and faster Data Transfer Processes… Read more

Customer Experience with Columnstore on ERP

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 has already been described here: https://blogs.msdn.microsoft.com/saponsqlserver/2017/04/13/using-columnstore-on-erp-tables. In the meanwhile, several customers tested this feature. They reported performance improvements for reporting scenarios using huge aggregations (see below). Other customers… Read more

SAP NetWeaver Installation on HANA database

This blog describes the SAP NetWeaver installation steps on the SAP HANA database – a step by step installation guide with the real screenshots! In this setup, the HANA Large Instance server is used to install the SAP HANA database, and SAP NetWeaver application layer runs on the Azure VM. This is a hybrid mode… Read more

File Server with SOFS and S2D as an Alternative to Cluster Shared Disk for Clustering of an SAP (A)SCS Instance in Azure is Generally Available

We are excited to announce general availability of clustering of an SAP (A)SCS instance on Windows Server Failover Cluster (WSFC) with file server, e.g. Scale Out File Server (SOFS) and Storage Spaces Direct (S2D) in Azure cloud. This is an alternative option for clustering of an SAP (A)SCS instance, to the existing option with cluster… Read more

Distributed Availability Groups extended

SQL Server 2016 supports distributed availability groups (AG) as additional HA feature of the engine. Today we want to show how this feature can be used to transfer near-real-time productive data around the globe. Based on Jürgens Blog about SQL Server 2016 Distributed Availability Groups we set up a Primary AG with the SAP Database (e.g…. Read more

Few interesting findings on HANA with MDC

Few interesting findings on HANA with MDC I was working on HANA with MDC and had few very interesting learnings. If you have been using non- MDC HANA databases, you may come across those scenarios. This article summarizes the issues and their resolutions. Setup Configuration I had following setup for SAP HANA during my testing…. 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