Skip to end of metadata
Go to start of metadata

PURPOSE

Here you can find important SAP notes about SQL Server (SMP/Launchpad login is required). They are divided and organized by subject.

FAQs

555223: FAQ: Microsoft SQL Server

Installation and Administration

 

SQL Server 2017

2492596 : Release planning for Microsoft SQL Server 2017

2484674 : Setting up Microsoft SQL Server 2017

2484657 : Configuration Parameters for Microsoft SQL Server 2017

 

SQL Server 2016

2313067: SAP Installation Media and SQL4SAP for SQL Server 2016
2263545: Trace flag 2371 not needed for SQL Server 2016
2313067: SAP Installation Media and SQL4SAP for SQL Server 2016
2263545: Trace flag 2371 not needed for SQL Server 2016
2294688: trace flags 1117 and 1118 not used in sql 2016

SQL Server 2014

1966681: Release planning for Microsoft SQL Server 2014
1966701: Setting up Microsoft SQL Server 2014
1986775: Configuration Parameters for SQL Server 2014
1970448: SAP Installation Media and SQL4SAP for SQL Server 2014
1961467: SQL Server 2014 and later - New Cardinality Estimation in Query Optimization

 

SQL Server 2012

1651862: Release planning for Microsoft SQL Server 2012
1702408: Configuration Parameters for SQL Server 2012
1676665: Setting up Microsoft SQL Server 2012
1684545: SAP Installation Media and SQL4SAP for SQL Server 2012

 

SQL Server 2008 (R2)

1076022: Release planning for Microsoft SQL Server 2008 (R2)
1152240: Setting Up Microsoft SQL Server 2008 (R2) 
1237682: Configuration Parameters for SQL Server 2008
1144459: SQL4SAP and SAP Installation Media for SQL Server 2008
1473016: Service Pack Installation for SQL Server 2008
1279358: Cumulative Update Installation for SQL Server 2008
1260968: COPYTOSHADOW: R3trans loses reports

 

TABLE OF CONTENTS

SAP BW on SQL Server

2116639: SQL Server Columnstore Documentation
2114876: Release Planning SAP BW for SQL Server Columnstore
1771177: SQL Server 2012 column-store support for SAP BW
1949486: SQL Server 2014 Columnstore support for SAP BW 

 

JDBC Drivers for MS SQL Server

639702: JDBC Driver for Microsoft SQL Server
745895: Available Microsoft JDBC drivers
2142959: Checking the version of JDBC driver for Microsoft SQL Server
1145221: JDBC driver exchange to Microsoft JDBC Driver
1109274: New JDBC driver for NetWeaver 7.0 and higher
1428134: sqljdbc driver fails to establish secure connection
2356977: Error during connection of JDBC Driver to SQL Server 

 

MS SQL Server licensing

1491158: Information about the Microsoft SQL Server license scope
2139358: Effect of changes in licensing terms of SQL Server
2173632: Clarification of Core based licensing

 

Non-Release Specific Support Information

62988: Service Packs for Microsoft SQL Server
1733195: Microsoft SQL Server version and download list
1660220: Microsoft SQL Server: Common misconceptions
398136: Support Policy for Microsoft SQL Server
1177356: MS SQL Server: End of Support for SAP Releases

SAP SQL Server Database Tools

1027512: MSSQL: DBA cockpit for basis release 7.00 and later
683447: SAP Tools for MS SQL Server

Database Connectivity / Database Librarly / Profile Parameter

1248222: ODBC DBSL profile parameters and connect options
208632: TCP/IP network protocol for MSSQL
128126: Database Connect for external tools
1601608: How to access an external SQL Server database
1644499: Database connectivity from Linux to SQL Server

Database Consistency Checks / Database Corruption

142731: DBCC checks of SQL Server
2138616: Advanced database check
1597910:  Handling of database corruptions on SQL Server

Database Migration / Copying Databases / Logins, Users and Schemas

767691: Migration of SAP Systems to/from MS SQL Server
151603: Copying an SQL Server database
1086375: There is already an object named '..' in the database
592514: MSSQL: internal database users, permissions and security
1294762: SCHEMA4SAP.VBS

Database Compression

1488135: Database compression for SQL Server
1459005: Enabling index compression for SQL Server

Database File Administration

1238993: Data File Management for SQL Server
363018: File management for SQL Server

Table Partitioning (SAP BW)

869407: Partitioning on MS SQL Server
1471910: SQL Server Partitioning in System Copies and DB Migrations

High Availability / Disaster Recovery (HA/DR) 

965908: SQL Server Database Mirroring and SAP Applications
493290: Configuring SQL server Log shipping
1772688: SQL Server AlwaysOn and SAP applications

Backup and Restore 

1297986: Backup and Restore strategy for MS SQL Server
1420452: FAQ: Restore and recovery with MS SQL Server

Performance 

General Performance

1744217: MSSQL: Improving the database performance
1241751: SQL Server minimal logging extensions
1134345: Using locked pages for SQL Server
929031: Using SQL Server Profiler for JAVA (and ABAP)
159171: Recompilation of Stored Procedures
2093615: Tips for opening Database Performance Incidents
987961: FAQ: SQL Server I/O performance
1747875: MSSQL: Performance problems when accessing certain tables

SQL Statement Performance (Optimizer Hints)

129385: Database hints in Open SQL
133381: Database-Hints in Open SQL for MS SQL Server
1552952: Parameter maxmarkercnt increased to 10000

Security

1380493: SQL Server Transparent Data Encryption (TDE)

 


Feedback

Please provide any feedback or questions regarding the content under the current page comments. If you have an issue or is looking for help, try to post your question on SAP community with Microsoft SQL Server tag.

In order to leave comments, you must be logged on with your SAP account.

  • No labels