This Blog will provide information about running SAP applications on SQL Server and Windows. The Blog is written by folks of Microsoft who are working with SAP and SQL Server for more than a decade.
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:
These SP stacks are prerequisites for using SQL Server column-store with SAP BW. We already described the SQL Server column-store in a previous BLOG (http://blogs.msdn.com/b/saponsqlserver/archive/2012/05/23/sql-server-2012-column-store-support-for-sap-bw.aspx).
In the meanwhile we implemented several improvements for the column-store. These improvements are delivered by means of a correction instruction in SAP note 1771177. This note has been released today.
The following improvements have been made since we posted our last BLOG:
For using the column-store, you have to perform the following steps:
You can download SQL Server 2012 CU2 (SQLServer2012_RTM_CU2_2703275_11_0_2325_x64) from http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2703275&kbln=en-us. Service Pack 1 of SQL Server 2012 is scheduled for November 2012. Once it is available, we recommend to install the service pack rather than applying the CU.
We also published an SAP SCN document, which describes the usage of the column-store with SAP BW in detail. This document is also attached to SAP note 1771177 and to this BLOG.