Skip to Content


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.


Four cyclists

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

man sitting in front of servers

SAP Systems on SQL Server 2017

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

MSDN Blog: SAP Support for SQL Server 2017

SAP Note 2492596

a person welding

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

document

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

rocket

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

two pages with play button

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

clock and gear

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

zigzag

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

clicking on mobile

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

book inside mobile

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


Latest Questions and Answers
How to setup MS-SQL Server connection in SAC 2019.9 version

Hi Team I hold Admin privileges & trying to define MS SQL Sever connection using SQL Databases option under Connection While defining connection in below window, passing below info for Location -> Def...

May 30th, 2019
System Refresh with partial data

Hi Guys, I want to perform the system refresh activity for BW development system from BW production system as a source, my question is that can we perform a refresh with the data for last 2 years only...

To find a new item not used in a previous document

I am checking some inventory transfers made and wonder if I could find a newly used item not found in previous document for an account. I am thinking using the OWTR and WTR1 table. Seems to be a does ...

How to connect SAP data to Sharepoint O365 or on permise

I'm very confused about determining a solution to connect SAP data to a SharePoint list or custom list. Simply all that I need is to find automatically all SAP data according to certain filtration " b...

SAP Business one SBO_SP_TRANSACTIONNOTIFICATION QUERY

Hello Experts, I will like to know if there was a way SAP Business one SBO_SP_TransactionNotification query will be able to validate concurrent transactions for sales order which will be checking the ...

SSIS Integration with SAP Hana Database

Dear All, one my client requirement, they want to create a data warehouse from SAP HANA Database. Currently, they are using SQL Server Server 2017 Standard edition and they want to extract data from S...


Latest Blogs
Fiori My Paystubs v3 and Performance in a Non-HANA Environment

The Situation You've implemented a shiny new Fiori Front End Server, configured Fiori Launchpad, and enabled the latest My Paystubs app (v3, from Fiori for SAP HCM 2.0). You've connected it to your ER...

May 21st, 2019
SAP to SQL Server PowerBI Integration without PI licences

Introduction The business requirement is to use MS Power BI for analytics by fetching Sales / Purchase details from SAP, worked around the same and started writing this blog. Prerequisites and Mapping...

April 23rd, 2019
Experiences with MS SQL Server's Implementation of the Column Store and SAP BW

In this post I want to share my experience with the implementation of the column store on the Microsoft SQL Server and Microsoft's port onto SAP BW. This post will not describe the technical informati...

March 7th, 2019
Zero Footprint DBACOCKPIT for remote SQL Server instances

Purpose of the tool Do you manage a large number of SQL Server instances running many different applications? Do they encounter critical performance problems from time to time? If that's the case then...

March 5th, 2019
ABAP Core Data Services | SAP Business Suite - Best Practice Guide

The ABAP Core Data Services (ABAP CDS) framework has been available since NetWeaver 7.40 SP05 and offers highly attractive features & benefits, e.g.: Many new SQL features: SQL joins: INNER JOIN, LEFT...

January 22nd, 2019
SAP File Share Cluster supported by SWPM

SAP introduced the concept of the File Share Cluster a while ago, along with instructions on how to manually configure or migrate to such a system. This new cluster configuration provides an alternati...

October 2nd, 2018

Back to top