SAP on SQL Server

SQL Server Columnstore for SAP

This blog introduces concepts, implementation and optimization of SQL Server Columnstore for SAP BW&ERP. 

Max Degree of Parallelism Option in SQL Server 2012 and higher  

Read this blog to learn more about the configuration option "Max degree of parallelism" (MaxDOP), which allows you to define the number of processors SQL Server can use in parallel to execute a single SQL query for your SAP application. This can help you achieve better performance with faster response times. 29 May 2015

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

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

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

Database Performance Warehouse Report Content

The Database Performance Warehouse uses the SAP BW content of the SAP Solution Manager to store database specific performance metrics. The DBA Cockpit within Solution Manager provides flexible analysis reports for these metrics based on BW technology. Learn more about how you can use the report content for capacity planning, trending analysis, troubleshooting, etc.. 15 Feb 2013

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.

SAP on SQL Server Document Archive

Here you can find all SAP on SQL Server archived documents.

For more information on SQL Server 2017, see following SAP Notes:

2492596 – Release planning for Microsoft SQL Server 2017

2484674 – Setting up Microsoft SQL Server 2017

2484657 – Configuration Parameters for Microsoft SQL Server 2017

Database Requirements for SAP NetWeaver

2329005 - Minimal DB system platform requirements for NW AS ABAP 7.51 INNOVATION PKG
2158828 - Minimal DB system platform requirements for SAP NetWeaver 7.5
1951491 - Minimal DB system platform requirements for SAP NetWeaver 7.4 SP08

NOTE: S-User authentification needed on Support Portal

New SAP Knowledge Base Articles released on 2017

2429388 - EWA: Cleanup Saplocks, Blocking Lockstats Jobs not Scheduled
2434546 - Error 650 occurs when executing ADD-FIELD
2433036 - Missing Index in Database
2417938 - SM21 shows "has_no_partition_boundary"
2426953 - SM21: Database Error 50000: SQL Server blocked access to pro
2430136 - MSSQL: How to cleanup 0MSS_C08* info cubes
2414788 - No suitable ODBC driver was found even though ODBC driver is
2415351 - SAP_SAPMonitor_<SID>_MSSQL_COLLECTOR fails with error 2812
2416544 - DBACockpit setup fails with SQL error 1326: ImpersonateWindo
2417829 - SMIGR_CREATE_DDL fails with "According ODS object has no act

NOTE: S-User authentification needed on Support Portal

Top Viewed KB articles in 2017

1744217 - MSSQL: Improving the database performance
1601608 - How to access an external Microsoft SQL Server database
1820508 - DBA Cockpit: Missing infocube indexes
1904412 - DBA cockpit connection XXX cannot be established
1478133 - How to analyze connection problems to database server
1660220 - Microsoft SQL Server: Common misconceptions
1744830 - How to reset DBACockpit settings for Solution Manager Wizard
2235057 - Performance issues during SAP Upgrade with SQL Server
1649078 - Disabling autostats for certain tables with SQL Server
2350473 - During system copy, R3load fails with DbSlErrorMsg rc = 20
2354379 - CREATE UNIQUE INDEX for EDOPROCSPINTDET fails during upgrade
1645041 - FAQ: Microsoft SQL Server logins and their usage in SAP envi
2221305 - Workaround to connect remote SQLServer from AIX, HP-UX or So
1736430 - SAP CCMS Cleanup Saplocks SQL Agent job is missing

NOTE: S-User authentification needed on Support Portal