SAPInst May Run Slowly on Windows 2012 or Windows 2012 R2

Almost all SAP products are now supported on Windows 2012 and SAP are in the process of certifying Windows 2012 R2.  Windows 2012 introduced a new feature called SMB 3.0.  Windows 2012 R2 introduces SMB 3.02 with support for running SQL Server over SMB.  SMB 3.0 features may cause SAPInst to run slowly. There is a… Read more

FAQs CHECKDB in SAP SQL Server Databases…Again

1.  What is CHECKDB? 2.  What is the reason for yet another post about CHECKDBs on SAP SQL Server databases? 3.  What is database corruption? 4.  What can cause database corruption? 5.  Why should you be concerned about corruption in a database? 6.  How does one learn that they have corruption in a database? 7.  What should you do when you encounter… Read more

Corruption Handling in SAP Databases

What is database corruption?  Why should you be concerned about corruption in a database?  What should you do when you encounter corruption in an SAP database on SQL Server?  This blog post is relevant for handling a corrupt SAP NetWeaver database on SQL Server.    Physical corruption happens on all database platforms with any Relational… Read more

Auditing – audit all except the SAPService

As the SAP database is one of most important assets you have, it makes sense to monitor any access to the database, that is not driven by the SAP System itself. You can do this by setting up an extended event session, that monitors all accesses, except these from the SAPService<SID> and SYSTEM account.  Normally… Read more

SAP on SQL General Update for Customers & Partners September 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

Virtualization – Overcommitting memory and how to detect it within the VM

Lately our SAP colleague Leslie Moser and myself got involved in a support case where a company had severe problems to keep their website up and running for days and weeks. When analyzing the outages, SAP Support found that the VM which ran SQL Server had on two occasions completely hung and the VM had… Read more

New Microsoft BI-SAP Integration whitepaper released

One of the areas we worked hard in the 2nd quarter of 2013 was to collect and document methods of how to integrate the Microsoft BI stack with SAP backend systems like SAP ERP and SAP BW. The result of this work meanwhile is documented and released as a whitepaper The paper gives an… Read more

SAP Private and Public Cloud Infrastructure -> Survey and Customer samples

Hello,     this is an experiment which I didn’t try yet via this blog. So let’s see if/how it works. Here is the idea behind it :1. a better understanding of customer environments helps to set the right priorities2. sharing SAP infrastructure architecture information should be useful for the whole community3. therefore I had the idea… Read more

9. Microsoft Private Cloud Solution for SAP: Landscape Design

Microsoft Private Cloud for SAP is built on fixed Virtual Machine and physical server “building blocks”  These configurations have been tested in lab environments and piloted at customer sites.  This document details how to consolidate an entire SAP landscape onto the four different Virtual Machine sizes and how to calculate how many physical servers are… 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