Quo Vadis SAP HANA – Erwartungen und Ausblick Jürgen Karnstädt HP SAP Competence Center Walldorf Mai 2013 Agenda • SAP HANA Vision • SAP HANA concept • HP in the SAP HANA market • SAP HANA scenarios • Motivation to move to SAP HANA • SAP HANA operation © 2013 SAP AG or an SAP affiliate company. All rights reserved. 2 SAP’s Real-Real Time Computing … … a business user dream becomes true © 2013 SAP AG or an SAP affiliate company. All rights reserved. 3 SAP HANA concept SAP HANA – Appliance Prerequisits Memory/CPU ratio = 128GB/CPU (valid for BW powered by SAP HANA) Support for INTEL EX CPUs only SUSE SLES Linux Rack servers (Scale UP) with internal disks: • Log volume - PCIe-Flash/SSD with performance threshold • Data volume - SAS / SSD with different performance threshold Scale out configurations with external storage: • Shared file-system for “Scale Out Solution” Successful validation required for successful certification 5 Westmere SAP HANA – How it integrates in SAP landscapes Typical SAP 2/3-tier client-server architectures Presentation SAP CRM SAP ERP SAP BW SAP Two-Tier Architecture SAP Three-Tier Architecture SAP Three-Tier Architecture with HANA SAP GUI / Any Input Device SAP GUI / Any Input Device SAP GUI / Any Input Device One Server (Central System) Multiple Servers Application Typically single instance Multiple Servers Single or multiple instances Single or multiple instances SAP NetWeaver technology platform Database Database Database SAP Sybase ASE, Oracle, MS SQL Server, IBM DB2, SAP liveCache, MySQL Max DB 6 © Copyright 2012 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. SAP HANA DB HP AppSystems for SAP HANA HP in the SAP HANA market SAP HANA - HP’s solutions portfolio HP AppSystems for SAP HANA Enterprise X-Small Scale-Up Small Scale-Up Medium Scale-Up Medium+ Scale-Up Large Scale-Up XL Scale-Out HP server ProLiant DL580 G7 ProLiant DL580 G7 ProLiant DL580 G7 ProLiant DL980 G7 ProLiant DL980 G7 Up to 16 ProLiant BL680c G7 Processor Two Intel x86-E7 Two Intel x86-E7 Four Intel x86-E7 Four Intel x86-E7 Eight Intel x86E7 4 Intel x86-E7 (Per Server) In-memory database 128 GB 256 GB 512 GB 512 GB 1 TB 512 GB (Per Server) Persistent storage 2x300 GB SAS Ext 24x146G SAS 2x300 GB SAS Ext 24x146G SAS 2x300 GB SAS Ext 24x146G SAS 2x300 GB SAS Ext 24x300G SAS 2x300 GB SAS Ext 24x300G SAS HP X9300 IBRIX Gateway HP P6550 EVA Low-latency log storage 1x320 GB FIO 1x320 GB FIO 2x320 GB FIO 2x320 GB FIO 4x320 GB FIO N/A Software SLES11 SAP HANA SLES11 SAP HANA SLES11 SAP HANA SLES11 SAP HANA SLES11 SAP HANA SLES for SAP SAP HANA HP Services for SAP HANA HP FastStart HP Technology Support HP FastStart HP Technology Support HP FastStart HP Technology Support HP FastStart HP Technology Support HP FastStart HP Technology Support HP FastStart HP Technology Support Single node 8 Scalable Industry-firsts from HP for SAP HANA Strength of the SAP and HP relationship “HP and SAP have been a winning combination for more than 20 years. We are truly proud of this partnership.” SAP product releases HP innovations Bill McDermott, Co-CEO, SAP, June 2011 Virtualized HP AppSystem for SAP HANA Test/Dev Disaster tolerance for scale-out solution Over 300 joint customer installations HP AppSystems for SAP HANA—scale out CRM on HANA HP CoE dedicated to inmemory technologies Hasso-Plattner Institute develops HANA on HP HP AppSystems for SAP HANA—single node Leading EML performance benchmark Project Kraken—12 TB development platform BWA co-innovation and leadership SAP HANA general availability BW on SAP HANA HP Business Suite on HANA 2010 and before 9 2011 2012 Now SAP HANA scenarios SAP HANA Innovation Overview HANA Accelerators Client Client SAP HANA DB Side-by-side scenarios 11 In seconds Accelerating existing transactions of the Business Suite More insight Exploring data loaded from Business Suite on any level of detail • CO-PA RDS • … • Ops. Reporting RDS • … Supercharged BW Speed up your BW without disruption • BW on SAP HANA SAP HANA DB Integrated scenario Innovation Functional apps natively built on SAP HANA, with or without Business Suite integration All-in-one – ultimate Business Suite solution fully integrated with and optimized for SAP HANA as database • CRM on HANA • Cash Forecasting • Smart Meter Analytics …… Apps AnyDB Apps BW SAP HANA DB Business Suite VDL AnyDB BW PLM SAP HANA DB SAP Business Suite SRM AnyDB (VDL) SAP Business Suite SCM SAP Business Suite / non-SAP Business Suite on HANA CRM SAP HANA DB Client HANA Apps (Next Generation & Strategic Investments) SAP ERP SAP Business Suite AnyDB HANA Analytics BW on HANA (Content & Virtual Data Layer) SAP HANA – Side car approach Many customers are using a side-car approach to start with HANA e.g.: - CO-PA Accelerator - Short implementation time - RDS available - Easy to implement in the data center 12 SAP HANA – CO-PA Accelerator Many customers are using that side-car approach to start with HANA SAP ERP 1 HANA Instance The data is replicated regularly to the HANA-system. CO-PA COPA reports are reading directly from HANA instead of the ERP database database. HANA DB any DB Customer Example Allocation costs Oracle 126 s HANA 6s Distribution sampling on customer level 32 s 2s Reporting: P&L Material view 63 s 6s 686 s 31 s Custom programs: sales variance 13 SAP BW on HANA Example of a Business Intelligence system landscape BW Accelerator 8x Blades Oracle Database 11g – 1x database server Traditional BW landscape SAP BWA SAP NW BW Datenbank 2x Application server 1x SSD Storage Example of a HANA system landscape SAP HANA appliance software Appliance with CPU, Storage and Memory Database in Memory OLAP Engine integrated in the database HANA Solution SAP NW BW SAP HANA Results with SAP HANA Simple business intelligence system landscape after migration to SAP HANA Number of servers without HANA Number of servers with HANA 8 2 ABAP Instance 1 1 JAVA Instance DB Server 1 1 1 ABAP Instance JAVA Instance DB Server BWA Blades Database size in TB 4.2 Database size in TB 0.35 Oracle 15 Reduce number of server‘s from 12 sever‘s to 3 server‘s Reduce database size from 4,2 TB to 350 GB - factor 13 HANA 0 BW Blades Results with SAP HANA Performance – Data load and activation process AR Reporting 3 Mio. records factor 170 Billing Documents 1,1 Mio records factor 30 11400 Min. 2010 Min. Without HANA 132 Min. 66 Min. HANA HANA Parallel 8 Min. Load 16 HANA Parallel 32 Min. 6 Min. Activation HANA DSO Load 3,7 Mio. records with HANA factor 36 for DS activation 6 Min. Load Parallel 26 Min. Without HANA DSO Load 3,7 Mio. Records without HANA 36 Min. 45 Min. Activation Parallel Load HANA 2 Min. 1 Min. < 1 Min. Load HANA Parallel Activation Activation Parallel SAP Business Suite on HANA App DB Server Server Test System 1 (any DB) Update to Suite on HANA 1.0 SP1 EHP616 SP0 • ERP 6.16 SP1, NW ABAP 7.40 SP1 Traditional SAP ERP system SAP ERP Database Timely independent from each other Test System 2 (HANA DB) App DB Server Server EHP616 SP0 Update to Suite on HANA 1.0 SP1 • ERP 6.16 SP1, NW ABAP 7.40 SP1 • HANA SP5, Latest Revision Level 48 HANA Solution SAP ERP SAP HANA Results with SAP Business Suite on HANA Key customer messages • HANA solution over all much faster than on the original database The Peformance in some improved areas is quiete impressive. Nevertheless some transactions are slower then in the tradidtional system. • How to deal with Customer Code • HANA appliance is working well, stable, no disruption Motivation to move to HANA Motivation to move to SAP HANA Replace Infrastructure Infrastructure refresh pending High Support High support to achieve performance Reduce hardware/administration costs High hardware/administration costs Technology Customer wants to use the newest technology 20 SAP HANA operation SAP HANA – Data Center readiness Backup/ Recovery • Lowest cost • Simplest solution • Point-in-time recovery • Disaster Recovery • Can be used to clone or copy systems System Replication • Can be used as Main HA failover for failures and planned downtime Host AutoFailover • Automatic detection and failover • Disaster Recovery • Requires spare server • Secondary system can be used for Test • Disaster Recovery • Can be used to clone or copy systems • No data loss Available for Scale-Up Solution Available for Scale-Out Solution 22 Storage Replication • No data loss systems Disaster tolerant solution for SAP HANA Coming later: HP AppSystems for HANA with Async DT* Mitigate risk Improve IT availability • Minimize direct financial impact • Prevent impact to reputation • Maintain productivity • Improve customer experience Reduce the cost of downtime • Improve time to recovery • Reduce resources required Two available solutions based on HP Continuous Access EVA and HP X9300 Network Storage System with SAN Boot 23 Synch DT (<50KM) © Copyright 2013 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. HP Restricted. Virtualized solution for SAP HANA Coming soon: HP AppSystems for HANA with VMware Customer benefits Cost savings • Run multiple HANA instances in single physical server Increased flexibility • Save significant time by deploying on a virtual machine Streamlined processes • Ease procurement and installation of SAP HANA 24 Available Q3 FY2013 Key differentiators • Optimized, tested, and tuned for VMware and SAP HANA • Templates for quick and easy deployment, updates and cloning SAP HANA system • HP Factory Express – Unique appliance delivery model HP ProLiant DL980 G7 (L) Server • Integrated management tools for easy and centralized monitoring and display D2700 Disk Enclosure Storage © Copyright 2013 Hewlett-Packard Development Company, L.P. The information contained herein is subject to change without notice. HP Restricted. Project Kraken Demonstrating SAP® Business Suite on HANA® Meeting SAP’s need for a technology platform to handle large amount of inmemory computing resources • Leadership platform • Biggest-ever HANA machine • Development platform for next-gen HANA (e.g. HydraLynx /DragonHawk) Watch: SAP Business Suite on HANA • Mission Critical environment “…we co-labored with HP to demonstrate a x-86 based160 core 8TB machine, nick-named Kraken running 200B scans per second…similar to the HP system we put together 20 years ago, just been updated with latest technology…” —Dr. Vishal Sikka CTO & Exec Board Member, SAP on Jan 10th 2013 @SAP Press Event 25 Thank you Contact information: [email protected] © 2013 SAP AG or an SAP affiliate company. All rights reserved.