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

SAP on SQL General Update for Customers & Partners January 2013

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.        New… Read more

SQL Server Column-Store: Updated SAP BW code

SQL Server column-store is generally supported by SAP BW since end of October 2012. One of the prerequisites is importing the correction instructions of SAP note 1771177. Last week we published a new version of this note with additional improvements. We recommend to update your SAP BW code by applying the new version of this… Read more

Effect of Windows Power Mode on SAP Netweaver Applications

Lately we had a customer changing the hardware in parts of their SAP application layer for their SAP ERP system. Goal was to reduce the number of servers with newer models which could deliver double the throughput with around the same latency as experienced before. Please also see an earlier article published in regards to… Read more

Confusion around Initial Values marker in SAP Table Definition

Lately we had some interesting discussions between our SAP Basis Team and some of our SAP developers. Reason was that there were several different opinions around what the column ‘Initial Values’ in the ‘Fields’ tap in SE11 really means (see below) Therefore let’s dig a bit deeper and explore how that column impacts how the… Read more