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.
Upgrade to SQL Server 2008 or SQL Server 2008 R2 with minimal downtime
In the last article I announced Microsoft running productive on SQL Server 2008 R2. In this article...
Author: Juergen Thomas - MSFT Date: 11/29/2009
Microsoft’s SAP ERP system productive on SQL Server 2008 R2
Two weeks ago Microsoft’s SAP ERP system went productive on CTP2 (also named August CTP) of...
Author: Juergen Thomas - MSFT Date: 11/27/2009
Version 2.3 of sap_use_db_compression released
Given that our own SAP Basis Team is pretty aggressively working with SQL Server 2008 R2 and plans...
Author: Juergen Thomas - MSFT Date: 10/11/2009
Two Questions in regards to UCS2 compression answered
I described UCS2 compression in the last article. It actually didn’t miss on questions on it...
Author: Juergen Thomas - MSFT Date: 10/11/2009
SQL Server 2008 R2 - UCS2 compression what is it - Impact on SAP systems
We just released CTP2 of SQL Server 2008 R2. What is this CTP? Think about it as Beta2 of SQL Server...
Author: Juergen Thomas - MSFT Date: 09/17/2009
New version of sp_use_db_compression available
First of all apologies for not being more active on our blogs site for the last two months. Reason...
Author: Juergen Thomas - MSFT Date: 08/22/2009
New SAP on SQL Server 2008 Whitepaper released
We finally made it to the finish line with the new Whitepaper describing SAP applications running on...
Author: Juergen Thomas - MSFT Date: 06/24/2009
SQL execution plans, part 3: how to get the plan
We already discussed when an execution plan is created and how long it is valid. We also had a look...
Author: Martin Merdes Date: 05/10/2009
Good Case study released on Customer who used SQL Server 2008 Database Compression
I just wanted to point all of you to a case study we just released about our customer Quanta out of...
Author: Juergen Thomas - MSFT Date: 03/30/2009
Measuring Memory Consumption of SAP Application Server Instances
Since the 'Green-IT' movement is becoming serious, leverage of server resources or power consumption...
Author: Juergen Thomas - MSFT Date: 03/26/2009
Applying SQL Server 2008 Database Compression to SAP systems which already ran on SQL Server 2000 RTM and SP1
Lately we had a strange incident when one of our customers for more than 10 years tried to apply SQL...
Author: Juergen Thomas - MSFT Date: 02/26/2009
SQL execution plans, part 2: SQL compilation
Today we want to have a closer look how an execution plan for a given SQL statement is created...
Author: Martin Merdes Date: 02/22/2009
Frequently asked Question - Why do we need SQL Server Enterprise Edition for SAP Netweaver based applications?
In these hard economic times we get to hear one question very often these days: Why do we need SQL...
Author: Juergen Thomas - MSFT Date: 02/19/2009
SQL execution plans, part 1: SQL statement execution on an SAP system
The most common root causes of a performance issue in an SAP system are slow I/O subsystems and...
Author: Martin Merdes Date: 02/09/2009
SAP declares support for SQL Server 2008 and Windows Server 2008
Great news arrived from SAP these days. SAP declared support for SQL Server 2008 and Windows Server...
Author: Juergen Thomas - MSFT Date: 01/29/2009
Procedure used for applying Database Compression to Microsoft SAP ERP system
As promised, we are publishing the stored procedure used to compress Microsoft’s SAP ERP system in...
Author: Juergen Thomas - MSFT Date: 11/24/2008
Update on Rollout of SQL Server 2008 Row Level Compression in Microsoft’s SAP ERP system
Well meanwhile the Roll-Out is as good as finished. The only tables remaining are some tables with...
Author: Juergen Thomas - MSFT Date: 10/30/2008
SQL Server SPs, CUs and hotfixes for SAP
The first cumulative update package (CU1) of SQL Server 2008 was released last week. You can...
Author: Martin Merdes Date: 09/29/2008
SQL Server 2008 Row Level Compression Roll-Out in Microsoft’s SAP ERP system
Lately a lot of questions came up around what our different compression types in SQL Server 2008...
Author: Juergen Thomas - MSFT Date: 09/29/2008
New Contributor to the blog “SAP on SQL Server”
I’m happy that I was able to win Martin Merdes as a contributor to this Blog. Martin is a...
Author: Juergen Thomas - MSFT Date: 09/19/2008
New and revised SAP OSS notes released
Last week we released a new OSS note regarding a new feature of SQL Server 2008 which so far is...
Author: Juergen Thomas - MSFT Date: 09/07/2008
Server running out of memory when copying backup files to other server
One of the common scenarios in the SAP space today is to perform a backup to local disks and then...
Author: Juergen Thomas - MSFT Date: 08/30/2008
Dealing with Scheduled Tasks in a SQL Server Environment using Database Mirroring
Since the introduction of SQL Server Database Mirroring the usage becomes more and more widespread...
Author: Juergen Thomas - MSFT Date: 08/22/2008
SAP OSS notes describing Improvements for SAP Unicode and SAP Platform Migration released
As most of people in SQL Server might know already, we released SQL Server 2008 at August 6th 2008....
Author: Juergen Thomas - MSFT Date: 08/15/2008
Windows and SQL Server Licensing under Virtualization
Windows and SQL Server Licensing under VirtualizationSince SAP more or less supported the usage of...
Author: Juergen Thomas - MSFT Date: 07/03/2008
SAP Beta Program for SQL Server 2008 started
First of all apologies for not having posted anything for 2 months. But looking back the last 8...
Author: Juergen Thomas - MSFT Date: 06/14/2008
How does Microsoft perform Backups in their SAP system landscape
This probably is one of the most asked questions we always get related to Microsoft’s SAP...
Author: Juergen Thomas - MSFT Date: 03/28/2008
Sporadic but periodic slow Inserts into a table - Why you should apply SQL Server 2005 SP2
Analyzing a SQL Query trace with SAP’s ST05 SQL Trace, a pattern could be observed which looks...
Author: Juergen Thomas - MSFT Date: 02/04/2008
Using SAP Code Inspector to improve Quality and Performance
Over the last few weeks we have been involved in the Go-Live of two bigger SAP ERP systems on our...
Author: Juergen Thomas - MSFT Date: 01/02/2008
Proportional fill and how to check whether it works
Being on a business trip in Japan a customer described a case where they had their SAP system...
Author: Juergen Thomas - MSFT Date: 12/01/2007
SAP Support for Windows Server 2008 and SQL Server 2008
Microsoft will release a new Windows Server product and a new SQL Server release next year. Windows...
Author: Juergen Thomas - MSFT Date: 10/14/2007
WebCast on SAP ERP Unicode Migration in Microsoft is available on Microsoft.com
Microsoft IT successfully performed a Unicode migration of their productive SAP ERP system in...
Author: Juergen Thomas - MSFT Date: 10/01/2007
What did we learn using Database Mirroring over the last two years in our SAP ERP system. Second revision
What did we learn using Database Mirroring over the last two years in our SAP ERP system. Second...
Author: Juergen Thomas - MSFT Date: 09/26/2007
SAP DBACockpit and some related SQL Scripts (Part 3)
Well, let’s go to the last part of our series about SAP DBACockpit and associated SQL Server...
Author: Juergen Thomas - MSFT Date: 07/30/2007
Hotnews 1067103 released by SAP this week
Some very hot news today literally. SAP engineers and we from Microsoft side investigated some...
Author: Juergen Thomas - MSFT Date: 06/28/2007
SAP DBACockpit and some related SQL Scripts (Part 2)
Index usageIn the second part we want to look at some new DMVs which for the first time also get...
Author: Juergen Thomas - MSFT Date: 06/12/2007
SAP Multi Instance Clustering
As most of folks who are busy in the SAP world know, SAP only had a very restricted amount of...
Author: Juergen Thomas - MSFT Date: 05/29/2007
SAP Application leveraging SQL Server Automatic Update Statistics
Hi folks, new Blog, new author. The Blog itself should give information about running SAP...
Author: Juergen Thomas - MSFT Date: 05/22/2007