Skip to Content
Microsoft SQL Server

Featured Content in SAP on SQL Server

Tags:

Updated Version for White Paper - SAP with Microsoft SQL Server: Best Practices for High Availability, Maximum Performance, and Scalability NEW !

Now available in its fourth edition with information for SQL Server 2014, SQL Server 2012, and SQL Server 2008R2. Read this white paper to know the best practices to install a high-availability SAP system on SQL Server 2014, SQL Server 2012, or SQL Server 2008R2, and to improve performance, scalability, and security. 01 Aug 2016

SQL Server I/O Requests Take Longer Than 15 Seconds

This blog explains the details for a common SQL Server error message. It helps better understanding and to classifying the underlying problem of the storage layer. 15 April 2016

Always On – Synchronize SAP Logon, Jobs and Objects

In an SQL Server AlwaysOn environment one of the challenges is the synchronization of SQL Server Agent job across all the AlwaysOn nodes. This blog provides an automated solution for this problem, based on a script developed by SAP. 15 April 2016

VMware vSphere 6 - fix for performance degradation due to hypervisor issue

VMware published the patch for ESXi 6.0 update 2 today. The VMware KB article has been updated at https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2129176

18 March 2016

SQL Server 2012/2014 "Best Practices" Paper published

A new version of the Whitepaper about SAP Workload on SQL Server was published, see:  https://blogs.msdn.microsoft.com/saponsqlserver/2016/03/07/whitepaper-sap-on-sql-server-2012-and-sql-server-2014

15 March 2016

Architecting Microsoft SQL Server on VMware vSphere – Best Practices Guide

A new Guide about configurations of vSphere as well as SQL server can be found at:  http://blogs.vmware.com/apps/2016/03/updated-architecting-microsoft-sql-server-on-vmware-vsphere-best-practices-guide.html

15 March 2016

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

SAP BW Columnstore Optimized Flat Cube on Microsoft SQL Server

Want to know more about the Columnstore Optimized Flat Cube, an alternative cube design available as of SAP BW 7.4 SP 8 on Microsoft SQL Server 2014? It uses the same simplified database structures as the HANA Optimized Cube resulting in simplified BW queries and reduced disk space usage. 31 Mar 2015

Using SQL Server 2014 In-Memory Optimized Columnstore with SAP BW

Learn how the SQL Server 2014 In-Memory Optimized Columnstore dramatically decreases disk space usage and improves BW query performance. Get to know all the benefits when using this feature. 31 Mar 2015

SAP Now Supports SQL Server 2014

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

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

Using SQL Server 2012 Column-Store with SAP BW

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 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

Former Member