New functionality in SQL Server 2014 – Part 5 – Backup/Restore Enhancements

Another area where new functionality was added or improved is the area of backup and restore. There are two major improvements to discuss and to introduce in this Blog. Backup Encryption The first one we want to discuss is the functionality of backup encryption. With SQL Server releases so far, one had two possibilities to… Read more

6. Microsoft Private Cloud Solution for SAP: Configuration of Cluster Shared Volumes, VHDX, Disks & LUNs

Microsoft Private Cloud for SAP requires specific configuration of Cluster Shared Volumes, Virtual Hard Disks and LUNs.  These configurations have been tested in lab environments and piloted at customer sites.  This document details the recommended configurations and naming conventions.  It is strongly recommended to follow this guidance.  The file 6. Microsoft Private Cloud Solution for… Read more

1. Microsoft Private Cloud Solution for SAP: Hardware, Network & SAN

Microsoft Private Cloud for SAP requires specific Hardware, Software, Network and Storage configurations.  These configurations have been tested in lab environments and piloted at customer sites.  This document details the CPU, RAM, Network and other configurations recommended to achieve consistent stable performance.  The file 1. Microsoft Private Cloud Solution for SAP: Hardware, Network & SAN.docx… Read more

How to Deploy SAP on Microsoft Private Cloud with Hyper-V 3.0

Windows Server 2012 includes powerful virtualization technologies that enable customers to improve flexibility, reduce H/W costs and improve performance. With this blog we are releasing to customers and partners detailed documentation on how to deploy and configure Windows Hyper-V as a consolidation tool for SAP.   1.        SAP on Windows Hyper-V Private Cloud Documentation Structure… Read more

SQL Server 2012 AlwaysOn – Part 12 – Performance Aspects and Performance Monitoring II

[Edit] You can find the summary of the complete series here. Moving to synchronous availability mode One thing we are not measuring in our tests with asynchronous availability mode is the impact of latency to transport the changes over to the secondary replicas. Looking in an earlier blog where we described the principle mechanisms of… Read more

SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring I

[Edit] You can find the summary of the complete series here. In this part of the series we want to look a bit more into performance aspects in deploying AlwaysOn and the way how one can monitor the requirements and also the impact of AlwaysOn. What are potential impacts? Independent on the Availability Mode being… Read more

AlwaysOn Part 10: Switching Scheduled tasks automatically

As we talked about leveraging Log-Shipping together with AlwaysOn in Part #10, it became apparent that one would need to enable or disable scheduled tasks automatically on the primary and secondary replica in order to: · Not flood the history files of the job with error messages telling that a backup can’t be taken from… Read more

AlwaysOn Part 9: AlwaysOn and Logshipping

[Edit] You can find the summary of the complete series here. In this part we want to talk about some scenarios where AlwaysOn and Log-Shipping is getting combined. The two scenarios we want to look into particularly would be: Despite the fact that we are using our 3-node AlwaysOn configuration (one primary and two secondary)… Read more

Reading from Database Mirroring or AlwaysOn Secondary Replicas in SAP Configurations

  Based on repeated customer questions, especially around the readable secondary of AlwaysOn, I would like to summarize in (quite) a few words the abilities to read from a secondary replica/mirror with the two main functionalities of SQL Server Database Mirroring (DBM) and AlwaysOn. Though SAP Netweaver applications are always requiring Read/Write access, a lot… Read more

SQL Server 2012 AlwaysOn – Part 8 – Failover Mechanism with SAP Netweaver

[Edit] You can find the summary of the complete series here. In part 8 of our series we want to look a bit behind the scenes how the SAP reconnect works together with the AlwaysOn. In part #7 we referenced already to failover exercises. We need to distinguish two parts. First is the SAP part… Read more