Pilot program for System Center Virtual Machine Manager 2012 SP1 connector for SAP LVM

SAP started the Ramp-Up program for SAP Landscape Virtualization Management 2.0. See https://service.sap.com/rampup for more details. Navigate to Ramp-Up Programs –> SAP NetWeaver –> SAP NetWeaver Landscape Virtualization Management 2.0. Microsoft will release a connector which will enable SAP LVM to use virtual machines that are running on Hyper-V and are managed by System Center… 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

Windows Server 2012 Generally Available for SAP NetWeaver – April 2013

Microsoft and SAP have been testing SAP products running on Windows Server 2012 since this new operating system was released in September 2012.  This process is now completed and SAP products are now released on Windows Server 2012.   1.        Windows Server 2012 is Now Generally Available for Systems Based on SAP NetWeaver Windows Server… Read more

Optimizing BW Query Performance

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/Optimizing-BW-Query-Performance/ba-p/367551 This blog post might be outdated by now. The latest documentation regarding SQL Server Columnstore on SAP is available in https://www.sap.com/documents/2019/04/023e5928-487d-0010-87a3-c30de2ffd8ff.html SAP BW query performance depends on many factors: hardware, database configuration, BW configuration and last but not least BW cube design and BW query design. When running… Read more

Deadlock Analysis (Basic)

Today I want to start a small blog series for the deadlock analysis with SQL Server. In the first part we will cover the basics about deadlocks, why and when they occur and how to capture them. The second part which will be more exciting will cover the basic analysis of deadlocks and the different… 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

SQL Server 2012: Installing SAP Solution Manager 7.1 SR1

This blog describes how you can install SAP Solution Manager 7.1 on SQL 2012 or perform a system copy. In addition, please always read SAP Note 1676665  – Setting up Microsoft SQL Server 2012 (Login required). Please use the SAP Software Provisioning Manager 7.0x (70SWPM) to install SAP Solution Manager 7.1. Read SAP Note SAP… Read more

SAP Software Provisioning Manager (70SWPM) for 7.0x

SAP has released a new version of the SAP Software Provisioning Manager (SWPM) which is called 70SWPM. It covers SAP NetWeaver 7.0x based products like SAP ERP 6.0 EHP6 or SAP CRM 7.0 EHP1 In detail, the 70SWPM can handle installations, system copies etc. for the following products SAP NetWeaver 7.0 including Enhancement Package 3… Read more