How to slowdown a SQL Server Database Backup

Yes, you read correctly. We are not talking about accelerating a SQL Server database backup. In our customer case we encountered the challenge to slow down the full database backup execution of a SQL Server database underneath the customer’s SAP ERP system. How did we get into this situation? In short the story reads: We… 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

SQL Server 2016 Distributed Availability Groups for SAP

As mentioned in an earlier blog, we wanted to introduce Distributed Availability Groups in a separate article. This is one of the articles. Just to refresh what Distributed Availability Groups are, here a pointer to the documentation: https://msdn.microsoft.com/en-US/library/mt651673.aspx However, please realize that some important commands/steps did not make it into the documentation as of 06/04/2016… 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

New Azure PowerShell cmdlets for Azure Enhanced Monitoring

As part of the announcement during the keynote at SAPPHIRE NOW to support SAP on Linux on Azure we released 5 Azure Quickstart Templates on github and 4 PowerShell cmdlets. For a description of the Azure Quickstart Templates, read the blog Azure Quickstart Templates for SAP Azure PowerShell cmdlets SAP on Linux on Azure is only… Read more

Azure Quickstart Templates for SAP

As part of the announcement during the keynote at SAPPHIRE NOW to support SAP on Linux on Azure we released 5 Azure Quickstart Templates on github and 4 PowerShell cmdlets. For a description of the PowerShell cmdlets, read the blog New Azure PowerShell cmdlets for Azure Enhanced Monitoring Azure Quickstart Templates The quickstart templates can… Read more

Protecting SAP Systems Running on VMware with Azure Site Recovery

Introduction Azure Site Recovery delivers a powerful toolset to customers seeking to deploy or improve their Disaster Recovery solutions. The key differentiators between Azure Site Recovery (ASR) and competing technologies: Azure Site Recovery substantially lowers the cost of DR solutions. Virtual Machines are not charged for unless there is an actual DR event (such as… Read more

SQL Server 2016 AlwaysOn for SAP

We know we are a bit late. But honestly we were very busy, also with exploring the great SQL Server 2016 features. That is why we did not write anything about SQL Server 2016 despite the fact that we are in the last phase of development and SQL Server 2016 launch to which we contributed as a… Read more

SQL Server has encountered I/O requests taking longer than 15 seconds

Most of us have seen these errors in the SQL Server error log pointing to a IO subsystem problem: 2015/06/15 12:43:01 spid8s SQL Server has encountered 1016 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [N:\ABCDATA8\ [ABCDATA8.ndf] in database [ABC] (5). The OS file handle is 0x000000000000172C.  The offset of the… Read more

Whitepaper SAP on SQL Server 2012 and SQL Server 2014

It has been a long while since we published the last whitepaper about SAP workload on SQL Server. It also has been a long while that we were working on a successor paper. Too long because we needed to revise the document several times in order to include new product releases and new functionalities. Since… Read more