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

SQL Server Column-Store available for all major SAP BW releases

Last Week SAP released Support Package Stack 5 for EHP1 of NetWeaver 7.3. Hereby all of the following equivalent SPS levels are now available: SPS 27 of SAP BW 7.0 (SAP NetWeaver 7.0) SPS 12 of SAP BW 7.01 (SAP enhancement package 1 for SAP NetWeaver 7.0) SPS 12 of SAP BW 7.02 (SAP enhancement… Read more

SAP starts Windows Server 2012 First Customer Shipment program

  SAP Windows Server 2012 First Customer Shipment program   we would like to point out that SAP started the Windows Server 2012 First Customer Shipment program ( FCS ). All the details can be found in the following two SAP notes : 1752767 : Release planning for Windows Server 20121753578 : Windows Server 2012… Read more

Microsoft and SAP NetWeaver – step by step up to the cloud – Part V : simple online SAP System copy

Intro   In my last blog I described how a simple “offline copy” of a SAP System could be accomplished : This time I would like to describe a solution which allows to create a simple online SAP system copy.A typical use case could be to create a copy of a production system which then acts as… Read more

SAP Software Provisioning Manager (SWPM)

SAP has released a new component of the SL Toolset which replaces the installation tools for SAP NetWeaver 7.3 and higher e.g. for products like PI 7.31 or BW 7.3 In detail, the SWPM can handle installations, system copies etc. for the following products SAP NetWeaver 7.3 SAP EHP1 for SAP NetWeaver 7.3 SAP NetWeaver… Read more