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 I’d like to tell more about how this upgrade was done with 5min downtime. Database Configuration of the Microsoft SAP ERP system As described in an earlier article on this blog (http://blogs.msdn.com/saponsqlserver/archive/2008/03/28/how-does-microsoft-perform-backups-in-their-sap-system-landscape.aspx), the HA configuration is based on… Read more

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 SQL Server 2008 R2. This move represents the most important step of 3 months testing of SQL Server 2008 R2 in sandbox systems, development and test systems. As throughout the whole testing period, the move to production was eventless…. Read more

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 to go productive on CTP2 of SQL Server 2008 R2 in 5 weeks from now, I needed to rework the stored procedure  sp_use_db_compression a bit. As I described in the former blog article, the way to get ALL data… Read more

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 as reaction of the blog. So let me try to address two of the questions in this blog One of the questions was how one would be able to detect whether UCS2 compression is used? The best answer one can… Read more

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 is that we are in the usual annual review phase and also went through a reorganization. Therefore I was pretty busy. Nevertheless I was able to spend some time improving the stored procedure one can use… Read more

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 on the factors which have an influence on the execution plan. SAP almost always executes parameterized statements on SQL Server. For details see: http://blogs.msdn.com/saponsqlserver/archive/2009/02/09/sql-execution-plans-part-1-sql-statement-execution-on-an-sap-system.aspx http://blogs.msdn.com/saponsqlserver/archive/2009/02/22/sql-execution-plans-part-2-sql-compilation.aspx Figuring out the execution plan of a long running SQL… Read more