Compressing an SAP database using report MSSCOMPRESS

SAP released the report MSSCOMPRESS in SAP note 1488135. The report can be used to compress existing tables and indexes using the data compression feature of SQL Server 2008 (and all newer releases). You can choose between the compression type NONE, ROW or PAGE for the data (heap or clustered index) and the (non-clustered) indexes…. 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

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

SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring I

[Edit] You can find the summary of the complete series here. In this part of the series we want to look a bit more into performance aspects in deploying AlwaysOn and the way how one can monitor the requirements and also the impact of AlwaysOn. What are potential impacts? Independent on the Availability Mode being… 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

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

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

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