SAP OS/DB Migration to SQL Server–FAQ v5.0 May 2013

The FAQ document attached to this blog is the cumulative knowledge gained from hundreds of customers that have moved off UNIX/Oracle and DB2 to Windows and SQL Server in recent years.  Intel based servers provide all of the required Enterprise Features at a fraction of the cost of UNIX hardware.  SAP provide fast, safe and… Read more

Auditing – audit all except the SAPService

As the SAP database is one of most important assets you have, it makes sense to monitor any access to the database, that is not driven by the SAP System itself. You can do this by setting up an extended event session, that monitors all accesses, except these from the SAPService<SID> and SYSTEM account.  Normally… Read more

Max degree of parallelism (MaxDOP)

The configuration option “Max degree of parallelism” (MaxDOP) defines how many processors SQL Server can use in parallel to execute a single SQL query. Setting this option to a value other than 1 may decrease the response time of a single, long running SQL command. However, this will also decrease the overall throughput and concurrency… Read more

SQL Server 2012 Enterprise Editions

Version 2.0. Please note additional comment in the section: ‘How do we change between different releases’ In this blog we want to shed some light into a topic that can develop into some confusion and which at the end might also cause some performance issues with customers running SQL Server 2012 with their SAP Netweaver… Read more

How many logical processors does SQL Server 2008 R2 Enterprise Edition support

I hope it is not too boring to bring up an article in regards to licensing. But this article by our team member Cameron on this blog site caused a quite bit of discussion. The key sentence in this article the discussions circled around this statement: SQL Server 2008 R2 Enterprise Edition allows a maximum… Read more

Whitepaper SAP on SQL Server 2012 and SQL Server 2014

It has been a long while since we published the last whitepaper about SAP workload on SQL Server. It also has been a long while that we were working on a successor paper. Too long because we needed to revise the document several times in order to include new product releases and new functionalities. Since… Read more

SAP on SQL General Update for Customers & Partners January 2013

SAP and Microsoft are continuously adding new features and functionalities to the SAP on SQL Server platform. The key objective of the SAP on Windows SQL port is to deliver the best performance and availability at the lowest TCO. This blog includes updates, fixes, enhancements and best practice recommendations collated over recent months. 1.        New… Read more

Data distribution and SQL Plans

For customers of SAP (and others) it is very important that the runtime of the different reports or programs is predictable, fast and stable. From time to time it happens that former fast query executions deteriorate in their runtime and need much more time than before. For most of the customers it is totally unclear… Read more