Browse by Tags

Tagged Content List
  • 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: SAP OS/DB Migration to SQL Server–FAQ v5.0 May 2013

    The FAQ document attached to this blog is the cumulative knowledge gained from hundreds of customers that have moved off UNIX/Oracle and DB2 to Windows and SQL Server in recent years. Intel based servers provide all of the required Enterprise Features at a fraction of the cost of UNIX hardware. SAP...
  • 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 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: 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: 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: 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 compression in general and how secondary index compression and page compression is used. The OSS note also has a new ABAP report MSSCOMPRESS attached which can be used to compress tables and indexes. One of...
Page 1 of 1 (10 items)