Browse by Tags

Tagged Content List
  • Blog Post: How to Size SAP Systems Running on Azure VMs

    Rahat Ahmad from our Partner Architect Team has contributed this blog. In one of the partner workshop last month, we had an interesting conversation around SAP Sizing principals and options on Microsoft Azure. As one of the prerequisites for SAP certification to run SAP Applications on Azure...
  • Blog Post: Clustering SAP ASCS Instance using Windows Server Failover Cluster on Microsoft Azure with SIOS DataKeeper and Azure Internal Load Balancer

    We released new white paper on clustering SAP ASCS instance using Windows Server Failover Cluster on Microsoft Azure public cloud. It describes how to install and configure a high-availability (HA) SAP central services instance ASCS in a Windows Failover Cluster (WSFC) using the platform Microsoft...
  • Blog Post: Max degree of parallelism (MaxDOP)

    The configuration option "Max degree of parallelism" (MaxDOP) defines how many processors SQL Server can use in parallel to execute a single SQL query. Setting this option to a value other than 1 may decrease the response time of a single, long running SQL command. However, this will also decrease the...
  • Blog Post: SAP OS/DB Migration to SQL Server–FAQ v5.3 April 2015

    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. In this document a large number of recommendations, tools, tips and common errors are documented. It is recommended...
  • Blog Post: Best Practices for Maintaining SQL Server SAP Systems

    The following recommendations are best practices for maintaining a SQL Server Netweaver database for an SAP implementation. The list is weighted heaviest from a Disaster Recovery perspective. For most of this audience, such critically important items are already well understood. But, unfortunately...
  • Blog Post: SAP on SQL General Update for Customers & Partners April 2015

    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: Concepts of SQL Server 2014 Columnstore

    SQL Server 2014 delivers two different in-memory features, which are both fully integrated into the SQL Server Engine: In-Memory Optimized Data Warehouse This feature is optimized for OLAP workloads and is implemented by two index types: The read-only Nonclustered Columnstore Index (NCCI) and writeable...
  • Blog Post: SQL Server 2014 Columnstore: Released for SAP BW

    SAP generally released SQL Server 2014 for SAP NetWeaver two weeks ago as announced in http://blogs.msdn.com/b/saponsqlserver/archive/2015/03/11/sql-server-2014-now-released-by-sap-for-sap-netweaver-7-xx.aspx As of last week, the SQL Server 2014 In-Memory Optimized Columnstore is generally available...
  • Blog Post: SAP Support for Microsoft KBA 2964518

    {NOTE – The SAP Note hyperlinks are only available if you have an S-User account for access.} Microsoft published KBA 2964518 that recommends a few different Trace Flags (TFs) in Table 1. SAP describes a list of TFs that it recommends to best support the SQL Server environment. For SQL Server...
  • 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...
Page 1 of 3 (71 items) 123