SAP on SQL Server

Want to get information about running Microsoft SQL Server in an SAP environment? Here you’ll find product documentation, blogs, articles, Q&As, SAP Notes, and more.

Featured Content

Whitepaper for SQL Server Columnstore for SAP

Learn about concepts, implementation, and optimization of SQL Server Columnstore for SAP BW & ERP

Read the whitepaper here

SAP Systems on SQL Server 2017

SQL Server 2017 is supported for some SAP NetWeaver based systems.

MSDN Blog: SAP Support for SQL Server 2017SAP Note 2492596

Updated Microsoft SQL Server Best Practices Guide for VMware vSphere 6.5

An updated version of the "Architecting Microsoft SQL Server on VMware vSphere®" guide for vSphere 6.5 has been published by VMware.

MS SQL Server on vSphere 6.5

Expert Content

SAP Note: FAQ Microsoft SQL Server in NetWeaver based systems

Have a look at the central resource with pointers to official SAP and Microsoft documentation regarding SAP NetWeaver on Microsoft SQL Server systems.

SAP Note 555223

SQL Server Columnstore on SAP ERP

In SAP NetWeaver on SQL Server 2016 and newer, you can define additional Columnstore Indexes for reporting. Customers have seen performance improvements by factors.

MSDN Blog: Customer Experience with Columnstore on ERP

New Version of the White Paper: Best Practices for SAP on SQL Server

Read the new version of the white paper covering best practices for high availability, maximum performance, and scalability for SAP on SQL Server 2014, 2012, or SQL Server 2008 R2

Read the MSDN Blog here

SQL Server I/O Requests Take Longer Than 15 Seconds

This blog explains the deatils for a common SQL Server error message. It will help you better understand and classify the unterlying problem with the storage layer

MSDN Blog: SQL Server has encountered I/O requests taking longer than 15 seconds

AlwaysOn - Synchronize SAP Logon, Jobs, and Objects

Read about how to synchronize the SQL Server Agent job across all AlwaysOn nodes in an SQL Server AlwaysOn environment.

MSDN Blog: Always On – Synchronize SAP login, jobs and objects

VMWare vSphere 6: Fix for Performance Degration Due to Hypervisor Issue

VMWare published the patch for ESXi 6.9 update 2.vFor more information, see the updated VMWare KB article

View the Article

Architecting Microsoft SQL Server on VMWare vSphere - Best Practices Guide

For information about configurations of vSphere and SQL Server, read the Best Practices Guide.

Updated: Microsoft SQL Server on vSphere Best Practices Guide