SAP Tools for MS SQL Server now part of SWPM

The SAP Tools for MS SQL Server (STM) used to be a separate download from the msplatforms space on the SAP Software Marketplace. For more information about the STM, see SAP Note 683447 (Login required) With the recent release of the SAP Software Provisioning Manager (SWPM), the STM are now part of the Generic Installation… Read more

How Update Statistics really works in SAP BW

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/How-Update-Statistics-really-works-in-SAP-BW/ba-p/367454 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 In the following we explain, how database statistics should be updated for SAP BW running on Microsoft Server. In particular, we describe the new feature “Lightweight Update… Read more

SAP BW improvements in new Support Package

This blog has been re-published at https://techcommunity.microsoft.com/t5/Running-SAP-Applications-on-the/SAP-BW-improvements-in-new-Support-Package/ba-p/367445 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 The latest SAP support packages contain a bunch of improvements for SAP BW running on Microsoft SQL Server. The improvements can be assigned to two areas: Support… Read more

SAP on SQL: General Update for Customers & Partners August 2012

SAP and Microsoft are continuously adding new features and functionalities to the SAP on SQL Server platform. In addition we have recently released both SQL Server 2012 and Windows 2012. This blog discusses the latest recommendations for customers running on SQL Server. This blog also has information for customers migrating from Proprietary UNIX systems to… Read more

SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.31

This blog describes how you can install SAP Systems based on SAP NetWeaver 7.31 on SQL Server 2012. In addition, please always read SAP Note 1676665  – Setting up Microsoft SQL Server 2012 (Login required). Some of the steps are only required if you install an SAP System that contains an ABAP stack (ABAP only… Read more

SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.30

This blog describes how you can install SAP Systems based on SAP NetWeaver 7.30 on SQL Server 2012. In addition, please always read SAP Note 1676665  – Setting up Microsoft SQL Server 2012 (Login required). Some of the steps are only required if you install an SAP System that contains an ABAP stack (ABAP only… Read more

Microsoft and SAP NetWeaver – step by step up to the cloud – Part IV : simple offline copy of a central system

Intro in the first three blogs of the series the following topics were discussed : 1. SCOM integration :     http://blogs.msdn.com/b/saponsqlserver/archive/2012/02/03/microsoft-and-sap-netweaver-step-by-step-up-to-the-cloud-part-i.aspx 2. automated installation of a dialog instance :     http://blogs.msdn.com/b/saponsqlserver/archive/2012/03/19/microsoft-and-sap-netweaver-step-by-step-up-to-the-cloud-part-ii.aspx 3. automated guest-OS Windows patching :     http://blogs.msdn.com/b/saponsqlserver/archive/2012/05/15/microsoft-and-sap-netweaver-step-by-step-up-to-the-cloud-part-iii.aspx   In part IV I want to talk about SAP system copy. This is another complex topic…. Read more

How to enable SAP "enhanced monitoring" via Powershell

Update Sep 27 2012 bug fix in PS script. An issue showed up using the script on a Windows 2012 server. The script failed to remove an entry from the two local user groups due to case sensitivity regarding the VM name.   Status Quo    I published a blog beginning of the year which describes… 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

SAP Support for SQL Server 2012

SAP now supports SQL Server 2012 for the following products: SAP Business Suite 2005 SR3 SAP CRM 5.0 Support Release 3 SAP ERP 6.0 Support Release 3 Update: SAP SCM 5.0 Support Release 3   SAP SRM 5.0 Support Release 3 SAP NetWeaver 7.0 Support Release 3 SAP Business Suite 2008 SR1 SAP CRM 7.0 Support… Read more