Browse by Tags

Tagged Content List
  • Blog Post: Required SQL Server patch for Columnstore

    This week we increased the minimum required SQL Server 2014 patch for using the Columnstore with SAP BW. You should upgrade to: SQL Server 2014 SP1 Cumulative Update 1 . As a matter of course you might apply any newer SQL Server Patch instead. You can always download the latest SQL Server...
  • 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: Columnstore Optimized Flat Cube in SAP BW

    With the general availability of SQL Server 2014, a new feature was released in SAP BW: The Columnstore Optimized Flat Cube. The prerequisites for the Flat Cube are described in in SAP Note 2114876 and in the following blog: http://blogs.msdn.com/b/saponsqlserver/archive/2015/01/08/sql-server-column...
  • 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: SQL Server Column-Store for SAP BW: Status and Release Planning

    Update in March 2015: Since SQL Server 2014 was generally released by SAP, the following SAP note was updated, too: SAP note 2114876 - Release Planning SAP BW for SQL Server Column-Store : Symptom You cannot use the new Writeable Clustered Columnstore Index of SQL Server 2014 out of the...
  • 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: SAP OS/DB Migration to SQL Server–FAQ v5.2 April 2014

    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...
  • 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 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: New Microsoft BI-SAP Integration whitepaper released

    One of the areas we worked hard in the 2 nd quarter of 2013 was to collect and document methods of how to integrate the Microsoft BI stack with SAP backend systems like SAP ERP and SAP BW. The result of this work meanwhile is documented and released as a whitepaper http://download.microsoft.com/download...
  • Blog Post: Analyzing JDBC connection issues

    Some customers do have connection issues between their SAP NetWeaver Java application server and SQL Server. Especially when they are trying to update or upgrade their SAP systems because some issues only occur if you use a more recent JVM patch level. The SUM logs contain exceptions like The driver...
  • Blog Post: SAP Support for SQL Server 2012 - Update

    SAP supports SQL Server 2012 for most SAP NetWeaver based products for quite a while – read my earlier blog post for more information. However, SAP now also supports products which are based on SAP NetWeaver 7.1 , SAP EHP1 for SAP NetWeaver 7.1 ( 7.11 ), SAP NetWeaver Composition Environment 7.1 ( CE...
  • Blog Post: SQL Server 2012: Installing SAP Solution Manager 7.1 SR1

    This blog describes how you can install SAP Solution Manager 7.1 on SQL 2012 or perform a system copy. In addition, please always read SAP Note 1676665  - Setting up Microsoft SQL Server 2012 (Login required). Please use the SAP Software Provisioning Manager 7.0x (70SWPM) to install SAP Solution...
  • Blog Post: SAP Software Provisioning Manager (70SWPM) for 7.0x

    SAP has released a new version of the SAP Software Provisioning Manager (SWPM) which is called 70SWPM. It covers SAP NetWeaver 7.0x based products like SAP ERP 6.0 EHP6 or SAP CRM 7.0 EHP1 In detail, the 70SWPM can handle installations, system copies etc. for the following products SAP NetWeaver 7.0...
  • Blog Post: SAP Software Provisioning Manager (SWPM)

    SAP has released a new component of the SL Toolset which replaces the installation tools for SAP NetWeaver 7.3 and higher e.g. for products like PI 7.31 or BW 7.3 In detail, the SWPM can handle installations, system copies etc. for the following products SAP NetWeaver 7.3 SAP EHP1 for SAP NetWeaver 7...
  • Blog Post: SAP Support for SQL Server 2012

    SAP now supports SQL Server 2012 for the following products: SAP Business Suite 2005 SR3 SAP CRM 5.0 Support Release 3 SAP ERP 6.0 Support Release 3 Update: SAP SCM 5.0 Support Release 3   SAP SRM 5.0 Support Release 3 SAP NetWeaver 7.0 Support Release 3 SAP Business Suite 2008 SR1 SAP CRM...
  • Blog Post: SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP3

    This blog describes how you can install the following products on SQL Server 2012 EHP2 for SAP CRM 7.0 EHP6 for SAP ERP 6.0 EHP2 for SAP SCM 7.0 EHP2 for SAP SRM 7.0 SAP NetWeaver 7.0 including EHP3 In addition, please always read SAP Note 1676665  - Setting up Microsoft SQL Server 2012 (Login required...
Page 1 of 2 (29 items) 12