Skip to Content

SAP on SQL Server

Actions


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
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...

Crystal Reports not running for Query using XML Path

Hi fellows, First question in this forum so please pardon me for any mistake. I am using the following query in of the view in SQL 2012 & my Crystal Report Version is 2012 query.jpg (See the attachmen...

SQL Server supported versions in BI Platform 4.2 Support Pack 5

Can someone help me identify which versions of SQL Server are supported with BI Platform 4.2 Support Pack 5 or any of the support packs?

SUM AND COUNT CONDITIONS IN SAP BUSINESS ONE SQL QUERIES.

HELLO EXPERTS, HOW CAN I PUT THE CONDITIONS OF SUM AND COUNT WHILE MAKING REPORT BY SQL QUERIES IN SAP BUSINESS ONE. FOR EXAMPLE :- I WANT TO SUM ALL QUANTITY IN THE REPORT OF SINGLE INVOICE.

SAP B1 Query

Hi Experts, I have an inventory aging query. "select t0.itemcode 'Itemcode',t0.Dscription 'Itemname', t0.Warehouse 'Whse', t0.OpenQty'BalQty',t0.OpenValue 'Value', Aging = Case when datediff(dd,t0.Doc...

Posting Journal Voucher Restriction

Hi Experts! Client company is using SAP B1 9.3 PL4 and multiple branches activated. They have around 15 branches, one user per branch is assigned. These users are able to create Journal Vouchers. As s...


Latest Blogs
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
The ABAP Detective Works the Flow (Chart)

Last month, I introduced a new path for myself in the Sequel – https://blogs.sap.com/2018/08/13/the-abap-detective-sequel/ I’ve moved to a work phase where instead of supporting an impending database ...

September 17th, 2018

Back to top