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

Protecting SAP Solutions with Azure Site Recovery

Protect SAP Applications Most large and medium sized SAP solutions have some form of Disaster Recovery solution. The importance of robust and testable Disaster Recovery solutions has increased as more core business processes are moved to applications such as SAP. Azure Site Recovery has been tested and integrated with SAP applications and exceeds the capabilities… Read more

High Available ASCS for Windows on File Share – Shared Disk No Longer Required

SAP Highly Available ASCS Now Supports File Share UNC Source SAP has released documentation and a new Windows Cluster DLL that enables the SAP ASCS to leverage a SMB UNC source as opposed to a Cluster Shared Disk. The solution has been tested and documented by SAP for usage in non-productive systems and can be… Read more

Migrating to SAP HANA on Azure

The S/4HANA platform on the SAP HANA DBMS provides many functional improvements over SAP Business Suite 7, and additions to business processes that should provide customers with a compelling reason to migrate to SAP S/4HANA with SAP HANA as the underlying DBMS. Another reason to migrate to S/4 HANA is that support for all SAP… Read more

Customer experience with SAP BW FEMS-Pushdown

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 meanwhile, a few customers who tested the new feature, provided feedback to the “SAP on SQL Server development”. Based on this feedback, we further improved the performance of… Read more

End to End Setup for SAP HANA Large Instances

So, you are ready for “SAP HANA on Azure Large Instances” deployment, Great! And, you want to know the step by step process with screen shots to start the work? Then you are reading the right article. This blog illustrates the various steps required for the SAP HANA on Azure Large Instances (or in short… 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

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