Browse by Tags

Tagged Content List
  • Blog Post: Client Aware Parameter for Multiple Clients has been Defaulted to Enabled

    Summary Customers running SAP systems with multiple clients may intermittently observe slow performance on some queries.   Sometimes the same query will run very quickly and sometimes the query will be very slow.   This problem is most likely to occur on systems with one very large client containing...
  • 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 – Part4 - In-Memory OLTP

    Besides Column Store Index, another large investment and focus for SQL Server 2014 is a feature which is in development for 4-5 years already. The origin task was to make SQL Server factors more efficient in high-end OLTP scenarios. Whereas efficiency did not primarily mean making the query execution...
  • Blog Post: Database Volume is compressed nicely – but now we want to shrink the data files

    Quite a few customers have implemented SQL Server Database compression on very large SAP databases and have reduced their actual database size by such a large factor that they now have terabytes of free space allocated to the SAP database files that they wish to reclaim. These customers have several...
  • Blog Post: New functionality in SQL Server 2014 – Part 3 – Low Priority Wait

    In order to explain what the ‘Low Priority Wait’ feature does, let’s first go into the background and describe the problem we wanted to solve with this functionality. SQL Server introduced Online Index maintenance and partitioned tables with SQL Server 2005. Though operations around...
  • 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: Virtualization – Overcommitting memory and how to detect it within the VM

    Lately our SAP colleague Leslie Moser and myself got involved in a support case where a company had severe problems to keep their website up and running for days and weeks. When analyzing the outages, SAP Support found that the VM which ran SQL Server had on two occasions completely hung and the VM had...
  • Blog Post: 9. Microsoft Private Cloud Solution for SAP: Landscape Design

    Microsoft Private Cloud for SAP is built on fixed Virtual Machine and physical server "building blocks" These configurations have been tested in lab environments and piloted at customer sites. This document details how to consolidate an entire SAP landscape onto the four different Virtual Machine...
  • 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: Effect of Windows Power Mode on SAP Netweaver Applications

    Lately we had a customer changing the hardware in parts of their SAP application layer for their SAP ERP system. Goal was to reduce the number of servers with newer models which could deliver double the throughput with around the same latency as experienced before. Please also see an earlier article...
  • 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 Enterprise Editions

    Version 2.0. Please note additional comment in the section: 'How do we change between different releases' In this blog we want to shed some light into a topic that can develop into some confusion and which at the end might also cause some performance issues with customers running SQL Server 2012 with...
  • 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: Too Many Virtual Log Files (VLFs) Can Cause Slow Database Recovery

    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...
  • 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: ABAP Select For All Entries - what is happening in SQL Server?

    One of the query types one gets confronted with when running SAP Netweaver based applications is a special form of Open SQL statement in ABAP which is called ‘For all Entries’ (FAE). Standard ANSI SQL does not contain the command SELECT FOR ALL ENTRIES and therefore this command can be translated...
  • 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: Uneven Windows Processor Groups

    The theme discussed in this blog does apply only to hardware which has more than 64 Logical Processors. All hardware with less Logical Processor threads exposed to the Operating System is not affected by the subjects described in this article. In these blog articles: http://blogs.msdn.com/b/saponsqlserver...
  • Blog Post: Changes to automatic update statistics in SQL Server – traceflag 2371

    When SQL Server introduced automatic update statistics with SQL Server 7.0 in 1998, the basic design was to keep track of the number of changes to a table. When the number of changes on a table exceeded a certain percentage threshold an automatic update of the statistics would be executed. Over the...
Page 1 of 2 (35 items) 12