Skip to end of metadata
Go to start of metadata

ALL USERS ARE INVITED TO CREATE CONTENT please follow the steps here 

SAP on SQL Server is a SCN Wiki space dedicated to provide SAP NetWeaver and MS SQL Server related content for the SAP community.

Want to find MS SQL Server specific information? Find out in the SAP on Microsoft Platform blog maintained by our Microsoft partners and also in Books Online.

Disclaimer: Content Accuracy is assured as much as possible. Discretion advised

 

 

Moderators:

Hanson Pan  | Cristina Ordas |   William Zanchet  

WIKI Space Editor: Cherry Tian

SAP Community Topic Page:
SAP on SQL Server

SAP Community Tags:
https://wiki.scn.sap.com/wiki/x/ORAIH

Blogs and Q&A tag: Microsoft SQL Server

Search for content
SAP on SQL Server Content

 

SQL Server 2017

SQL Server 2017 Important Notes

NOTE: S-User authentification needed on Support Portal to fully read SAP Notes

SQL Server 2016

 

FAQs about SQL Server 2016

SQL Server 2016 Important Notes

NOTE: S-User authentification needed on Support Portal to fully read SAP Notes


SQL Server 2014

FAQs about SQL Server 2014

SQL Server 2014 Important Notes

NOTE: S-User authentification needed on Support Portal to fully read SAP Notes


SQL Server 2012

FAQs about SQL Server 2012

SQL Server 2012 Important Notes

NOTE: S-User authentification needed on Support Portal to fully read SAP Notes


SQL Server 2008 (R2)

FAQs about SQL Server 2008 (R2)

SQL Server 2008 (R2) Important Notes

NOTE: S-User authentification needed on Support Portal to fully read SAP Notes


Featured content by Development Support

Here you can find entries that were recently shown in https://www.sap.com/community/topics/sql-server.html but have been removed.

 

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.

News from Product Support

SAP now supports SQL Server 2017 with SAP products based on SAP NetWeaver ABAP 7.0 and higher and SAP NetWeaver JAVA 7.1 and higher! (2018. Aug 1st Updated)

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

Watch out!
Help!
  • WIKI Help
  • Contact Moderators via contact information at top of page
Last updated

Recently Updated

  • No labels