Browse by Tags

SQL Server column-store is generally supported by SAP BW since end of October 2012. One of the prerequisites is importing the correction instructions of SAP note 1771177 . Last week we published a new version of this note with additional improvements. We recommend to update your SAP BW code by applying...

In the following we explain, how database statistics should be updated for SAP BW running on Microsoft Server. In particular, we describe the new feature “Lightweight Update Statistics”, which speeds up by factors SAP BW process chains containing Update Statistics. The implementation of...

The latest SAP support packages contain a bunch of improvements for SAP BW running on Microsoft SQL Server. The improvements can be assigned to two areas: Support for SQL Server 2012 column-store. We will describe this in detail in a separate BLOG. An overview can be found at http://blogs.msdn...

The Transaction Log of a SQL Server database is composed of one or more physical files. For each database, SQL Server only writes to one physical transaction log file at a time. Although some firms choose to have more than one physical log file, the general guideline for SAP databases on SQL Server is...

The cost based query optimizer of SQL Server relies on actual index and column statistics. SAP strongly recommends setting the database options AUTO_UPDATE_STATISTICS and AUTO_CREATE_STATISTICS. As a result, statistics are automatically maintained. We recently described the details in the following BLOG...

The creation of database indexes is often a significant part in SAP BW process chains. Even on up-to-date database servers the index creation on a BW cube may take several hours. The obvious way to speed-up this procedure would be to increase parallelism by setting the SQL Server configuration option...

Microsoft’s internal ERP solution is the SAP Suite of products including SAP ECC 6.0, SAP BW and SAP SCM. Microsoft tests new SQL Server releases and Service Packs on not only test SAP systems but also the core ECC Production system that runs Microsoft worldwide. The ECC 6.0 single instance, single...

SAP encourages their customers to convert existing non-Unicode systems to Unicode. However, several SQL Server customers hesitated to perform a Unicode Conversion, because of the increased storage requirements of UCS-2. This issue has been finally solved with Unicode-compression, which is a new feature...

In Microsoft we founded a LOB Practice team a few years back. The first focus of the team was SAP. Hence we hired industry talent out of the SAP space to build the team. People who were running SAP Basis teams or who worked as Enterprise Platform architects in SAP customers or partners of SAP joined...

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...

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...

Microsoft will release a new Windows Server product and a new SQL Server release next year. Windows Server 2008 (formerly ‘Longhorn’) should release in Q1 of CY2008 whereas SQL Server 2008 (formerly ‘Katmai’) will be released in summer CY2008. As usual pre-released versions of Windows Server 2008 and...