Global Advisory Firm Improves SAP BW Performance and Lowers Costs by Moving SAP Landscape to Windows & SQL Server on Azure and Hyper-V
Published Mar 13 2019 10:31 AM 146 Views
First published on MSDN on Jul 16, 2015

The Australian subsidiary of a Global Advisory and Accounting Practice has migrated their SAP landscape from HPUX/Oracle running on Superdome UNIX servers to Windows and SQL Server running on Azure and Hyper-V.


At the same time SAP BW performance has improved greatly and SAP Business Warehouse Accelerator has been decommissioned and replaced with SQL Server 2014 in-memory Column Store technologies


Non-production SAP systems have been moved onto the Microsoft Azure cloud platform while production runs in a hosted data centre on Hyper-V.  Azure Site Recovery based on Hyper-V replica is used to synchronize the SAP landscape to Azure to provide Disaster Recovery services in a world class data centre at a reasonable cost.



1.        Business Problem & Technological Obsolescence


The customer required a flexible and cost effective solution to replace their existing UNIX/Oracle landscape that was end of life.  Rather than simply moving the existing SAP landscape from HPUX/Oracle to Windows and SQL Server, the customer wanted to lower TCO, improve performance and leverage new technologies.


The customer wanted to incorporate modern technologies into their solution to create a platform that will allow them to operate their SAP landscape into the future in a cost effective manner



2.        Deployment of New Technologies


BNW Consulting is a SAP cloud and migration partner based in Melbourne, Australia that has done some of the first SAP on Azure deployments.  The partner briefed the customer on several new technologies and how that could allow the customer to lower TCO and add value to the organization:



1. Move non-production SAP systems from on-premises to Azure.  This eliminates the need to buy servers and storage as well as the benefits of instant and elastic provisioning


2. Leverage SQL Server 2014 database compression.


3. Convert SAP BW cubes from Btree tables and indexes to SQL Server 2014 Column Store.  The performance gains and storage efficiency allowed the customer to terminate the use of SAP Business Warehouse Accelerator, a product that was found to be by the customer expensive and difficult to manage in cloud and hosted data centers


4. Run SAP on high performance low cost 2 socket Intel commodity servers and virtualize both the database servers and application servers with Windows 2012 R2 Hyper-V.  SAP on SQL Server is certified and supported by numerous different hardware vendors, on multiple hyper-visors and on at least two public cloud platforms.  SAP on SQL Server does not require any specialized appliances.


5. Deploy world class Disaster Recovery technologies based on Azure Site Recovery to replicate the production Virtual Machines to Azure




3.        SAP OS/DB Migration Process


BNW Consulting migrated the following systems from HPUX/Oracle to Windows 2012 R2 and SQL Server 2014


·        SAP ECC 6.0 Ehp4


·        Enterprise Portal 7.01


·        Business Objects 14.0.5


·        Business Warehouse 7.30


·        Solution Manager 7.02


·        NWDI 7.01


·        PI 7.11


·        CRM 5.0


At the same time the following systems were converted from non-Unicode to Unicode


·        SAP ECC 6.0


·        Business Warehouse 7.30


·        CRM 5.0



The total end to end downtime for migrating ECC was 24 hours


The total end to end downtime for migrating BW was 12 hours


Entire Production landscape was migrated in one weekend including end user validation and verification and handover to business by 3PM on the Sunday of the migration.



SQL Server 2014 Page compression reduced the database sizes



Software



Source Database Size



Target Database size



SAP ECC 6.0



950 GB



496 GB



SAP Business Warehouse



1382 GB



648 GB ( 475 GB after cubes changed to Column Store)



SAP CRM



281 GB



161 GB




Warwick Chai the Director of BNW said “Using the latest OS/DB Migration tools from SAP in combination with very powerful high performance Intel servers BNW is able to migrate any customer of virtually any size in a weekend.  We have done this for customers with database sizes more than 10TB and achieve a throughput of around 2TB per hour”.



4.        SAP BW on SQL Server 2014 in-memory Column Store – Performance Gains


SAP BW performance improved after migrating to SQL Server 2014 and the implementation of Column Store.  All cubes other than real time cubes were converted to Column Store.  Performance with the combination of SAP BW on SQL 2014 + Column Store has proved to be faster than the previous Oracle platform and SAP BW Accelerator.  Therefore SAP BW Accelerator has been discontinued from the customer landscape.



SQL Server 2012 first introduced a read only Column Store.  SAP integrated the read only Column Store index to the SAP BW E Fact cube object some years ago and shipped this functionality in SAP Support Packages.


SQL Server 2014 extended the capabilities of the Column Store to include writable scenarios including:


-Column Store on E Fact cube


-Column Store on F Fact cube


-Column Store on SAP BW Flat Cube



Storing data in Column Store format reduces the amount of storage needed and greatly improves performance.  SQL Server Column Store technologies also accelerate performance by storing data in-memory in a dedicated buffer.  This buffer has a much larger object size than the conventional 8kb disk block cache that the core SQL Server engine uses.



The performance gains for a sample of BW reports ranged from 1% - 90% faster with BWA decommissioned and no longer in use.  BW Admin activities such as loading also speed up.





5.        Business Benefits


The customer was able to migrate their entire landscape in 4 months and with minimal to no disruption to their business operations.



Unlike moving BW Systems to HANA, SQL Server Column Store technologies are available on all releases of SAP BW starting from BW 7.0 up to BW 7.4.



Warwick Chai said “BNW wanted to deliver a modern and flexible platform for the customer, leveraging the best of new technologies rather than just doing a like-for-like swap from UNIX/Oracle to Windows and SQL Server. This provides them with a platform for the future, utilizing the latest Microsoft technologies and allows them to take advantage of the features and functionality the products provide”.



6.        Technical Details



In order to support SQL Server 2014 and enable the Column Store features for BW some SAP support packages were applied.  Some minor BW Administration settings had to be changed to decommission and remove SAP Business Warehouse Accelerator from the landscape.



Entire target  customer environment listed below.  Always check the relevant SAP Notes to determine the required support packs and notes



SAP Software



ABAP



JAVA



Unicode



Windows  2012 R2



SQL 2012 required patches



SQL 2014 required patches



SAP Product



ECC



7.01 SP13



7.01 SP13



Yes



Yes



SP 11



7.01 SP15



Supported



EP



-



7.01 SP14



Yes



Yes



jdbc upgrade



jdbc upgrade



Supported



BO



14.0.5



-



Yes



Yes



4.1+



Supported



BWA



7.20.26.0



Yes



n/a



<retire>


Replace with SQL 2014 column store



BW



7.30 SP10



7.30 SP10



Yes



Yes



SP 7 / BW 7



SP10 (BW SP11)




Supported



SM



7.02 SP15



7.02 SP15



Yes



Yes



SP 11



SP14 (BW SP15)



Supported



NWDI



<tbc>



-



Yes



Yes



jdbc upgrade



Supported



TREX



7.10.39.00



-



Yes



Yes 7.1 SP60+



<retire>


column store



PI



7.11 SP12



7.11 SP12



Yes



Yes



SP 10



SP12



Supported



CRM



7.00 SP29



7.00 SP28



Yes



Yes



SP26



SP29




Local Redundant storage is used for the database and Geo Redundant for backups


Azure Site-2-Site VPN has been used to seamlessly link the Azure VNET to the customer network.



VM sizes = D13 for database server and A5 SAP application servers


30 x VMs protected via Azure Site Recovery


8 x databases synchronized with Azure via SQL Server AlwaysOn (asynchronous mode)


All systems are virtualized using Microsoft Hyper-V 3.0 / Windows 2012 R2 on two socket commodity Intel servers each with 384GB of RAM and rated approximately 55,000 SAPS.



The databases are backed up using the SQL Server 2014 Backup to URL feature. SQL Server Transparent Data Encryption has been used to protect at rest data and backups.   There has been a considerable reduction in the amount of storage and the cost of storage as Azure storage is very reasonably priced.


The Azure VMs running SQL Server are storing SQL Server datafiles directly onto Azure blob storage.



The latest version of SAP Solution Manager was installed and configured as this was more cost effective than migrating the previous Solution Manager.  The latest SAP Business Objects release was installed and the configuration migrated using the BOE “Promotion Management” tool.



Links


SAP Migration Partner www.bnw.com.au



SAP OS/DB Migration to SQL Server–FAQ v5.3 April 2015


Protecting SAP Solutions with Azure Site Recovery


Columnstore Optimized Flat Cube in SAP BW


Concepts of SQL Server 2014 Columnstore


SQL Server 2014 Columnstore: Released for SAP BW


SQL Server 2014 now released by SAP for SAP NetWeaver 7.xx


SQL Server Column-Store for SAP BW: Status and Release Planning




1969259 - LCM CLI Master Note - How to promote thousands of objects across BI4 environments?

Version history
Last update:
‎Mar 13 2019 10:31 AM
Updated by: