Skip to end of metadata
Go to start of metadata

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.

  • No labels