Browse by Tags

Tagged Content List
  • Blog Post: SAP Notes around Azure released

    Yesterday SAP released SAP Notes around Azure as IaaS platform for SAP software. With the release of these SAP Notes SAP officially supports Azure as a platform for production systems with a combination of SAP products, Operating Systems and DBMS systems. Let’s go through the information briefly...
  • 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 5 – Backup/Restore Enhancements

    Another area where new functionality was added or improved is the area of backup and restore. There are two major improvements to discuss and to introduce in this Blog. Backup Encryption The first one we want to discuss is the functionality of backup encryption. With SQL Server releases so far...
  • 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: Auditing – audit all except the SAPService

    As the SAP database is one of most important assets you have, it makes sense to monitor any access to the database, that is not driven by the SAP System itself. You can do this by setting up an extended event session, that monitors all accesses, except these from the SAPService<SID> and SYSTEM...
  • 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: SAP Hyper-V benchmark Released

    We usually don’t use this site to promote every benchmark which we conduct and finish with one of our trusted hardware partners. However for a benchmark we released on Friday 21 st of June together with HP, we want to make an exception. In summer 2012, HP and Microsoft decided to invest into a...
  • Blog Post: FAQs Around Kerberos and SQL Server

    Recommended Audience: Developers, DB Administrators and System Administrators Estimated Depth Level: 200 {100 easiest, 400 hardest} This blog post is a rehashing of information that can be found in other locations on the web in regards to Kerberos and SQL Server. In our SAP world we occasionally...
  • Blog Post: SQL Server 2012 AlwaysOn – Part 12 – Performance Aspects and Performance Monitoring II

    Moving to synchronous availability mode One thing we are not measuring in our tests with asynchronous availability mode is the impact of latency to transport the changes over to the secondary replicas. Looking in an earlier blog where we described the principle mechanisms of AlwaysOn ( http://blogs...
  • Blog Post: SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring I

    In this part of the series we want to look a bit more into performance aspects in deploying AlwaysOn and the way how one can monitor the requirements and also the impact of AlwaysOn. What are potential impacts? Independent on the Availability Mode being synchronous or asynchronous, AlwaysOn will...
  • 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: Deadlock Analysis (Basic)

    Today I want to start a small blog series for the deadlock analysis with SQL Server. In the first part we will cover the basics about deadlocks, why and when they occur and how to capture them. The second part which will be more exciting will cover the basic analysis of deadlocks and the different approaches...
  • Blog Post: AlwaysOn Part 10: Switching Scheduled tasks automatically

    As we talked about leveraging Log-Shipping together with AlwaysOn in Part #10, it became apparent that one would need to enable or disable scheduled tasks automatically on the primary and secondary replica in order to: · Not flood the history files of the job with error messages telling that...
  • Blog Post: AlwaysOn Part 9: AlwaysOn and Logshipping

    In this part we want to talk about some scenarios where AlwaysOn and Log-Shipping is getting combined. The two scenarios we want to look into particularly would be: Despite the fact that we are using our 3-node AlwaysOn configuration (one primary and two secondary) which followed us through multiple...
  • Blog Post: Reading from Database Mirroring or AlwaysOn Secondary Replicas in SAP Configurations

    Based on repeated customer questions, especially around the readable secondary of AlwaysOn, I would like to summarize in (quite) a few words the abilities to read from a secondary replica/mirror with the two main functionalities of SQL Server Database Mirroring (DBM) and AlwaysOn. Though SAP Netweaver...
  • 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...
Page 1 of 3 (59 items) 123