Browse by Tags

Tagged Content List
  • Blog Post: SAP on SQL General Update for Customers & Partners April 2014

    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...
  • Blog Post: SQL Server Column-Store with SAP BW Aggregates

    Last week we extended the SAP BW support for SQL Server 2012 column-store by releasing SAP note 1951490 . The correction instructions of this note contain several improvements. The most important one: You can now use the column-store for BW aggregates. It is not restricted any more to BW basic cubes...
  • Blog Post: Increasing BW cube compression performance

    Last year we already released an SAP note regarding BW cube compression performance, containing a correction instruction. The text of this note has been updated last week. We released additional, new correction instructions for the BW cube compression in a new SAP note together with other improvements...
  • Blog Post: New functionality in SQL Server 2014 – Part 2 – New Cardinality Estimation

    Introduction One area where a lot of development work went into SQL Server 2014 is the area of query optimization where a crucial component got re-written in order to improve query access and predictability. To get a better idea about the significance of the change and the way how we deal with...
  • Blog Post: New functionality in SQL Server 2014 – Part 1- Modifiable Column Store Index

    As you dear reader realized, there was not that much activity on our blog over the last few months. Reason for the lower output of blogs certainly has to do with work that the team is performing right now in different projects with SAP. One of the projects we were working on hard is SQL Server 2014....
  • Blog Post: Infrastructure Recommendations for SAP on SQL Server: “in-memory” Performance

    In recent years the capabilities of Intel and AMD commodity servers have grown exponentially. Processing power (SAPS) has increased and the cost of RAM has decreased dramatically. SQL Server leverages these developments in hardware technologies with features that reduce storage and memory footprint such...
  • Blog Post: Optimizing BW Query Performance

    SAP BW query performance depends on many factors: hardware, database configuration, BW configuration and last but not least BW cube design and BW query design. When running a query, there are several caches involved: disk caches, database caches and the BW OLAP cache. You should keep this in mind when...
  • Blog Post: SQL Server Column-Store: Updated SAP BW code

    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...
  • Blog Post: SQL Server Column-Store available for all major SAP BW releases

    Last Week SAP released Support Package Stack 5 for EHP1 of NetWeaver 7.3. Hereby all of the following equivalent SPS levels are now available: SPS 27 of SAP BW 7.0 (SAP NetWeaver 7.0) SPS 12 of SAP BW 7.01 (SAP enhancement package 1 for SAP NetWeaver 7.0) SPS 12 of SAP BW 7.02 (SAP enhancement...
  • Blog Post: How Update Statistics really works in SAP BW

    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...
  • Blog Post: SAP BW improvements in new Support Package

    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...
  • Blog Post: SQL Server 2012 Column-store support for SAP BW

    SQL Server 2012 introduced an additional storage format for data. Besides the normal row-oriented store, there is a column-oriented store as well (like in SAP HANA). In order to make it as transparent as possible, the new column store got exposed to the Database Administrators and Applications as a new...
  • Blog Post: Auto Update Statistics Async in SAP NetWeaver

    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...
  • Blog Post: Performance of index creation

    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...
  • Blog Post: Decreased disk space requirement for SAP Unicode systems

    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...
  • Blog Post: SQL Server Page Compression became default for SAP

    SAP supports SQL Server Data Compression (row- and page-compression) for all applications based on ABAP application server as of NetWeaver (NW) Basis 7.00 and SQL Server 2008. Per default, SAP used to create tables with compression type ROW and indexes with compression type NONE. This decision was made...
  • Blog Post: Increased partition support of SQL Server in SAP BW

    As of SQL Server 2005 you can partition table and indexes. The maximum number of partitions used to be 1,000 for SQL Server 2005, 2008 and 2008 R2. Some customers were reaching this limit when running SAP Business Warehouse (SAP BW) on Microsoft SQL Server. Therefore it was decided to increase this limit...
  • Blog Post: Extracting hierarchies from SAP BW 7.3

    1. the issue In 2009 Microsoft certified the Microsoft Connector 1.1 for extracting data from SAP BW 7.x via the Open Hub Service API : The SSIS connector for SAP BW is for free but has to be downloaded from the SQL Server "feature pack". Here is a link to the 2008 R2 feature pack : http...
  • Blog Post: PowerPivot – a new way of MS BI integration with SAP BW and non-SAP data sources

    1. the issue and how it was handled in the past The issue and how it was handled in the past is already described in my last blog where I showed how SQL Server Reporting Services 2008 R2 can be used to solve the problem : SSRS 2008 R2 - a new way of MS BI integration .....   2. how the issue could...
  • Blog Post: 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 some non-SAP data sources people usually recommended to first consolidate and load everything into a single system ( either SAP BW or SQL Server/SSAS ). Any kind of reporting or data analysis would then...
  • Blog Post: 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)...
  • Blog Post: Choosing SQL Server compression type for SAP

    Depending on the SAP and SQL Server release, there are different compression types supported by SAP NetWeaver. Unfortunately the naming convention used by SAP and Microsoft is not consistent. Therefore there was some confusion about this in the past. In SAP notes the following compression types are mentioned...
  • Blog Post: 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 our specialist for SAP BW and integration of Microsoft products into SAP BW. Hermann is part of our onsite team in the SAP Netweaver Development in Germany Scenario: The most important advantage of table...
Page 1 of 1 (23 items)