Running SAP Applications on the Microsoft Platform
This blog provides information about running SAP Applications on the Microsoft Platform. The blog is written by people who are working with SAP on the Microsoft Platform for decades.
Changes to automatic update statistics in SQL Server – traceflag 2371
When SQL Server introduced automatic update statistics with SQL Server 7.0 in 1998, the basic design...
Author: Juergen Thomas - MSFT Date: 09/07/2011
Decreased disk space requirement for SAP Unicode systems
This blog has been re-published at...
Author: Martin Merdes Date: 09/05/2011
How to integrate SQL Server specific hints in ABAP
Working on a few Proof of Concepts this year where customers moved their SAP landscapes from Oracle...
Author: Juergen Thomas - MSFT Date: 08/31/2011
SQL Server Page Compression became default for SAP
This blog has been re-published at...
Author: Martin Merdes Date: 08/22/2011
Problems with mounted volumes in a Cluster
As Cameron pointed out in his Blog about SAP on SQL Installation on Mount Points, there are a bunch...
Author: Clas Hortien Date: 07/22/2011
SAP on SQL Installation on Mount Points
Several customers have recently asked about extending a disk online and installing SAP systems on...
Author: Cameron - MSFT SAP Program Manager Date: 06/09/2011
Accelerating Oracle -> SQL Server Migrations with Fusion-io ioMemory
We have recently completed several migrations at customer sites using Fusion-io ioMemory Devices to...
Author: Cameron - MSFT SAP Program Manager Date: 06/09/2011
Customer Proof of Concept on New HP DL980
Recently we conducted a Performance Proof of Concept for a large customer using the new 8 Intel...
Author: Cameron - MSFT SAP Program Manager Date: 06/09/2011
NIPING – a useful tool from SAP
This article got motivated by a customer support case we lately engaged in. The issue in the case...
Author: Juergen Thomas - MSFT Date: 04/26/2011
Changes in affinity settings of SQL Server 2008 R2 to support > 64 Logical Processors
In earlier articles on this blog we talked about the fact that SQL Server 2008 R2 Enterprise Edition...
Author: Juergen Thomas - MSFT Date: 04/20/2011
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...
Author: Juergen Thomas - MSFT Date: 04/18/2011
Increased partition support of SQL Server in SAP BW
This blog has been re-published at...
Author: Martin Merdes Date: 03/18/2011
SQL Server network encryption with SAP
Reason Defense, Security, Public Safety, Government and Financial customers sometimes require...
Author: Sebastian Dusch - AzureCAT Date: 03/09/2011
Online Disk Extension & Windows 2008 R2 Dynamic Memory are Fully Supported for SQL Server
Online Disk Extension & Windows 2008 R2 Dynamic Memory are Fully Supported for SQL Server...
Author: Cameron - MSFT SAP Program Manager Date: 02/20/2011
Installation & Configuration of Windows NFS Client to enable Windows to Mount a UNIX File System
Installation & Configuration of Windows NFS Client to enable UNIX to Windows to Mount a UNIX...
Author: Cameron - MSFT SAP Program Manager Date: 02/03/2011
Extracting hierarchies from SAP BW 7.3
- the issue In 2009 Microsoft certified the Microsoft Connector 1.1 for extracting data from SAP BW...
Author: HermannDaeubler Date: 01/18/2011
SAP BW 7 and SQL Server 2008 Star Join Optimization
Table of contents :1. Intro2. Sample query using SQL Server 20053. Sample query with star join...
Author: HermannDaeubler Date: 12/03/2010
SAP Support of Windows Server 2008 R2
Since this is my first blog entry, I’ll start with a little introduction: I’m a...
Author: Sebastian Dusch - AzureCAT Date: 11/15/2010
Column Statistics – No need to create them manually
Lately we stumbled over a few customers which showed us some funny list of indexes, when using...
Author: Juergen Thomas - MSFT Date: 11/12/2010
PowerPivot – a new way of MS BI integration with SAP BW and non-SAP data sources
- the issue and how it was handled in the past The issue and how it was handled in the past is...
Author: HermannDaeubler Date: 11/04/2010
SSRS 2008 R2 – a new way of MS BI integration with SAP BW and non-SAP data sources
1. the issue In customer scenarios with the requirement to integrate data out of SAP BW with...
Author: HermannDaeubler Date: 11/03/2010
Compressing an SAP database using report MSSCOMPRESS
This blog has been re-published at...
Author: Martin Merdes Date: 10/08/2010
SAP Now Support In Place Upgrade of Windows for SAP Systems
In Place Windows UpgradesIt is now possible to upgrade the operating system of a SAP ABAP or Java...
Author: Cameron - MSFT SAP Program Manager Date: 10/04/2010
Some interesting Blog Entries in the Blog site of our Microsoft LOB Practice team
In Microsoft we founded a LOB Practice team a few years back. The first focus of the team was SAP....
Author: Juergen Thomas - MSFT Date: 09/30/2010
Partitioning Large NUMA Based Servers into Smaller SAP VMs - Question from Jason
Partitioning Large NUMA Based Servers into Small VMs - Question from JasonThe idea of using a large...
Author: Cameron - MSFT SAP Program Manager Date: 09/28/2010
Windows 2008 R2 - Groups, Processors, Sockets, Cores Threads, NUMA nodes what is all this?
Windows 2008 R2 - Groups, Processors, Sockets, Cores Threads, NUMA nodes what is all this? Industry...
Author: Cameron - MSFT SAP Program Manager Date: 09/27/2010
Windows 2008 R2 Performance Monitor – Processor Information Counters have replaced Processor Counters
SAP will soon support Windows Server 2008 R2. There were massive changes in this Windows release in...
Author: Juergen Thomas - MSFT Date: 09/24/2010
Choosing SQL Server compression type for SAP
This blog has been re-published at...
Author: Martin Merdes Date: 09/21/2010
SQL 2008 R2 is now fully supported by SAP
SAP have announced full support of SQL 2008 R2SAP has announced the full General Availability and...
Author: Cameron - MSFT SAP Program Manager Date: 09/17/2010
Secondary Index Compression and Page compression supported by SAP
Today OSS notes # 1488135 and #1459005 was released by SAP. The first note explains SQL Server...
Author: Juergen Thomas - MSFT Date: 09/10/2010
SAP Landscape Management with SQL Server Policies
In SQL Server 2008 the ability to check and configure multiple SQL Server systems with a...
Author: Clas Hortien Date: 09/08/2010
Update to the SAP on Oracle -> Windows/SQL Server OS/DB Migration FAQ
OS/DB Migration FAQ has been updated with easy instructions on how to create a Windows Export Server...
Author: Cameron - MSFT SAP Program Manager Date: 08/14/2010
Two Database Mirroring cases in one week - one solution
Within a week we had two customers contacting us because of strange behavior they saw around SQL...
Author: Juergen Thomas - MSFT Date: 07/14/2010
SAP OS/DB Migration to SQL Server - FAQ
How to Greatly Speed Up Migrations from Oracle/DB2 to SQL Server Microsoft has developed some...
Author: Cameron - MSFT SAP Program Manager Date: 07/05/2010
New Cluster Quorum Models in Windows 2008
We Highly Recommend the New Quorum Models in Windows 2008Microsoft Cluster Services has been...
Author: Cameron - MSFT SAP Program Manager Date: 06/29/2010
Frequently Asked Questions we heard on the SAP on SQL 2008 Training course this year
Frequently Asked Questions from SAP on SQL Training During the last 12 months I have taught the...
Author: Cameron - MSFT SAP Program Manager Date: 06/28/2010
10 Reasons to Upgrade SAP systems to Windows 2008 / Windows 2008 R2
Benefits of upgrading Windows 2003 to Windows 2008 for SAP Systems Microsoft has released Windows...
Author: Cameron - MSFT SAP Program Manager Date: 06/21/2010
Another great use of SQL Server Database Mirroring
A while back one of our SAP customers benefited from Database Mirroring after the NAS device...
Author: Juergen Thomas - MSFT Date: 06/18/2010
Analyzing Statements with Extended Events (Extended Events Part II)
Clas Hortien offers us another great article as next part of his series on XEvents. Great work Clas...
Author: Clas Hortien Date: 06/16/2010
Extended Events with SAP (Part I)
Here is another great contribution by Clas Hortien in regards to new technologies which got...
Author: Clas Hortien Date: 05/26/2010
Sensitive question – CHECKDB when and how to execute it in large SAP systems
As the data volumes of our customers increase more and more often questions come up whether to run...
Author: Juergen Thomas - MSFT Date: 04/29/2010
SQL Server Change Data Capture with SAP
Hello I am pleased to introduce Clas Hortien as new contributor to this blog site. He is located in...
Author: Clas Hortien Date: 04/01/2010
Updated version of sp_use_db_compression – Version 2.42
In regards to SQL Server 2008 R2, I worked on some more options of the procedure to compress tables....
Author: Juergen Thomas - MSFT Date: 03/17/2010
And another question around SQL Server Database Compression answered
In the earlier post, I mentioned a customer who reduced their SAP BW data volume from 2.3TB to...
Author: Juergen Thomas - MSFT Date: 03/16/2010
One question around SQL Server Database Compression
Just a short note on a question which came up in a lot of customer meetings around SQL Server...
Author: Juergen Thomas - MSFT Date: 03/16/2010
Deletion of request in SAP BW orders of magnitude faster after installing SQL Server 2008 SP1 CU6
Welcome Hermann Daeubler on this blog site. Hermann is Program Manager in SQL Server Development and...
Author: Juergen Thomas - MSFT Date: 02/13/2010
Performance – what do we mean in regards to SAP workload?
Today we received an email that came from a Microsoft consultant who is working with a SAP customer...
Author: Juergen Thomas - MSFT Date: 01/24/2010
New hashkey algorithm for lockhash values introduced in SQL Server 2008 R2
Hello folks, I wish you all a Happy New Year 2010. I only wanted to point your attention to a blog...
Author: Juergen Thomas - MSFT Date: 01/21/2010