SAP on SQL ServerWhere is this place located?

Log in to follow, share, and participate in this community.

Overview

Here you can find resources and guides to help you install or upgrade your SAP system with MS SQL Server.

Space editors:

Heiko Schultze, Elisabeth Anzer

Moderators:

Clas Hortien

Related Resources

12-month Leaderboard

Featured Content

SAP Now Supports SQL Server 2014 NEW !

SAP now supports SQL Server 2014 with SAP products based on SAP NetWeaver 7.0 and higher (including all Enhancement Packages) and SAP NetWeaver 7.1 to 7.4 and higher (including all Enhancement Packages). For more information on SQL Server 2014, see SAP Notes 1966681, 1966701  (SMP login required),  and the FAQs. 11 Mar 2015

 

Customizing End-to-End SQL Server Monitoring in Solution Manager 7.1 NEW !

Learn more about the capabilities to monitor a Microsoft SQL Server database within SAP Solution Manager 7.1 and how to modify the standard SAP template to create alerts on other metrics associated with a SQL Server database. 02 Feb 2015

 

Supported SQL Server Version for SAP NetWeaver 7.4 SR2

Note that for SAP NetWeaver 7.4 SR2 (SAP NetWeaver 7.4 SP8)  only SQL Server 2012 is supported. 21 Oct 2014

 

Analyzing Network Errors on SQL Server

SAP application servers occasionally lose connections to the SQL Server database server. This paper discusses how to approach the problem of solving intermittent connection loss, and some common causes of connection problems. Important SAP notes and the preferred problem-solving approach are identified. 19 Feb 2014

 

SQL Server 2012 Column-Store Available For All Major SAP BW Releases

SQL Server 2012 introduced a new storage format for data. Besides the traditional row-oriented store, there is now also a column-oriented store available. The column-oriented store is optimized for aggregating mass data, while the row-oriented store can be optimally used when accessing just a single row. SQL Server 2012 column-store support has been integrated into all major SAP BW releases. You can now benefit from increased query performance and reduced disk space requirements. 05 Nov 2012

 

Immense Disk Space Savings with SQL Server

Database compression dramatically reduces the disk space needed for an SAP NetWeaver system running on SQL Server. As of SQL Server 2008 R2, this uses an improved encoding algorithm for Unicode, also known as Unicode-compression. This results in less storage requirements for SAP Unicode systems. For more information, see this blog. In May 2011, SAP changed the default compression type from ROW to PAGE compression, which led to an additional reduction in the database size. For more information, see this document. 22 Sep 2011

 

The Most Viewed SAP on SQL Server Presentations

Check out the mostly viewed SAP on SQL Server presentations.

 

 


See more recently featured content

Recent Activity

Refresh this widget
Load more items

Formatted Text

Advertising Widget

Advertising Widget

Advertising Widget