SAP HANA On POWER Technology - Status And Outlook
SAP HANA on POWER Technology- Status and Outlook Ralf LoiIBM SAP Solution - Technical Support
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources2
Important Disclaimer Copyright IBM Corporation 2014 All rights reserved.U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corp.THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSESONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THEINFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OF ANYKIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON CURRENT THINKINGREGARDING TRENDS AND DIRECTIONS, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUTNOTICE. FUNCTION DESCRIBED HEREIN MY NEVER BE DELIVERED BY I BM. IBM SHALL NOT BERESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE RELATED TO, THISPRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS PRESENTATION ISINTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR REPRESENTATIONSFROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND CONDITIONS OF ANYAGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR SOFTWARE.DISCLOSED UNDER NDAIBM, the IBM logo, ibm.com and DB2 are trademarks or registered trademarks of International BusinessMachines Corporation in the United States, other countries, or both. If these and other IBM trademarked termsare marked on their first occurrence in this information with a trademark symbol ( or ), these symbolsindicate U.S. registered or common law trademarks owned by IBM at the time this information was published.Such trademarks may also be registered or common law trademarks in other countries. A current list of IBMtrademarks is available on the Web at “Copyright and trademark information” atwww.ibm.com/legal/copytrade.shtml3
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources4
SAP HANA (High Performance Analytics Appliance) An in-memory Database– column oriented– compressed– most beneficial for OLAP read queries An „Appliance“ ?– available only on Linux/Intel servers today– standardized and certified solution stacksdeployable on selected Intel based servers– TDI tailored data-center integrationre-use existing IT assets (storage)– HEC HANA Enterprise Cloudsubscription based cloud services A Platform– SAP Analytics and ERP applications– Non-SAP environments5
SAP HANA on IBM POWER SAP HANA on Power is targeting enterprise customers requiring anSAP HANA-based solution on IBM Power Systems servers IBM intention is not to offer it as an appliance, but in a flexible formcombining the HANA license from SAP and IBM Power Systemsservers, middleware and services.6
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources7
HoP (HANA on Power) History2012-04PoC started (SAP, HPI and IBM)2012-08HANA code compiled/linked (all available components built )2012-10Technical feasibility demonstrated for OLAP engine, ( 300 changes)2013-01Vishal Sikka (SAP CTO) announced POWER Interest to press2013-04Linux on Power Proof-of-Concept Status Complete.2013-08SAP initiates Product Development Program for HANA on IBM Power technology2013-12HANA code optimized compiled/linked (HANA SPS08, SLES11SP2)2014-02IBM code checked in, full function testing commencing, Power 8 discussions2014-03Vishal Sikka (CTO SAP) and Steve Mills (IBM SVP) agreement to move forward2014-06SAP announced “Test and Evaluation Program”2014-10SAP announced “Ramp up Early Adopter”2015-05SAP announced HANA on Power2015-08HANA on Power is in GAGoingForwardTechnologyRoadmap asprovided bySAP8
Annuncio SAP di GA di HANA on ystems/9
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources10
Business ApplicationsGBSTraditional x86 HANA StackSAP HANA SUSE Linux Enterprise ServerRedHat Enterprise LinuxHW Platform(Server Storage)ToolsGTS / ITSXFS or GPFS11
Plus HoP AdaptionsBusiness ApplicationsGBSTraditional x86 HANA StackSAP HANA ITMTSMIBM compl. SW(scale-out filesystem)planSUSE Linux Enterprise ServerRedHat Enterprise LinuxHW Platform(Server Storage)GTS / ITS / STG LSGPFSPOWER compliant12
Support for SAP HANA SPS 11SAP HANA SPS 11“With SAP HANA version for IBM Power Systems architecture SAP extended the support of alreadysupported hardware platforms to also include the IBM Power Systems family. As of SAP HANAPlatform SPS 11, SAP no longer distinguishes both versions.”(nota 2133369) Certified also for Power Same technological functionalities (e.g. Multitenant DB Container, Log Shipping for data replication,Predictive Analysis, Spatial etc.)13
IBM Power: SAP BW Benchmark World Record – 2B recordsBenchmark status: February 20164.8191.8Xmore per core2.1162.2842.3952.5262.65514
POWER8 HighlightsAnnounced 2013 at Hot Chips Conference12 Cores per Socket/ChipSignificantly Strengthened Cores8 threads per core (SMT8)Wider fetch / dispatch/issue of instructions (8 fetch / dispatch, 10 issue)Doubled highly utilized execution unitsLarger Caches per core/regionL1: 64K data “D” Cache, 32K instruction “I” Cache per coreL2: 512K private per coreL3: 8M per core (up to 96MB per chip)L4: external to the chip2 Integrated Memory Controllers w/ Improved Latency & bandwidth 25% memory latency improvement via on-chip fastpath interconnect16MB mem cache / buffer chipIntegrated SMP Interconnect w/ improved “Flatness”2-Hop fabric topologyIntegrated IO SubsystemOn Chip PCIe ControllerFine Grained Power ManagementOn Chip Power Management Controller & Power gating15
Faster Memory Bandwidth ideally fits demand of SAP(in-memory) applicationsSource: IBM CPO16
Comparisons to Intel Systems17
Power Systems RAS versus x86Application/Partition RASLive Partition MobilityLive Application MobilityPartition Availability priorityPOWERx86YesYesYesYesYes, support issuesNoSystem RASOS independent First Failure Data CaptureMemory Keys (including OS exploitation)Processor RASProcessor Instruction RetryAlternate Processor RecoveryDynamic Processor DeallocationDynamic Processor SparingMemory RASChipkill Survives Double Memory FailuresSelective Memory MirroringRedundant MemoryI/O RASExtended Error HandlingI/O Adapter Isolation (PI-Bus and TCEs)YesYesEX – MCA RecoveryYesYesYesYesNoNoNoNoYesYesYesYesYes, some vendorsYes, optionalNoYesYesYesNoNoNoSee the following URLs for addition details: 18
Power Systems Partitioning PowerVM certified withSAP HANA Can run full SAP stack(not only HANA) More than one HANAsystem per boxApp XSAPAPPLLinuxHANAQAHANADEVAIXSAPi5/OSSAP HANADBPRODTenant DBApp YTenant DBCross-tenant accessVIOSSAP HANADBPRODSystem DB Coexistence betweenall operating systemssupported (AIX, Linux,IBM i)SAP HANAShared LPARs in PoolsDedicated or Dedicated Donating LPARsPowerVM HypervisorExample: Power Systems E870 or E880 Only HANA ProductionLPAR with dedicateddonating cores19
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources20
HANA - Sizing HANA Sizing is SAP's responsibility. IBM did not produce sizing tools for System x HANA systems. SAP has published extensive guidelines and data on sizing HANA systems.Refer to: 013/01/17/sap-hanasizing http://www.saphana.com/docs/DOC-2114 tem/21
Sizing Considerations for Power Systems platforms Memory Sizing: Memory sizing method is similar to Memory Sizing for HANA onIntel. For initial sizing use the SAP Quicksizer http://service.sap.com/sizing For migration sizing you need to create a sizing report: Find more details here:https://websmp103.sap-ag.de/ sapidb/011000358700000319402014E CPU Sizing: The limiting factor is the memory sizing. SAP states a ratio of up to 50GB per core for BW, and 96 GB per core for Business Suite (subject to change). Storage Sizing: Following the TDI approach, individually tailored configurations Read more: ISICC Forum: d 4f7f-8bd4- 0335729472bd SAP HANA on Power FAQ: ba57d9a7d-4b43-a6bf-299d08e5841222
HoP – What’s supported (1/2)SAP Business Warehouse SAP NetWeaver BW version 7.31 or higherScale-Up and Scale-Out (multi-host) up to 16x 4.8TB nodes ( 76TB)SAP BPC 10.1 (in Controlled Availability)SAP BO BI 4.1SAP Hana Dynamic Tiering (SPS 11) Production: Non-Production: POWER8, min 8 core/128 GB POWER8 or POWER7 , min 2 core Server S82X e E850: No fixed GB/core ratio 32 GB/core LPAR configured in the shared max 3 TBprocessor pool Server E870 e E880 50 GB/core max 96 core/4.8 TB LPAR configurated as dedicated or dedicated donating23
HoP – What’s supported (2/2)SAP Suite on Hana (SoH) SAP ERP 6.0 EHP7SAP SRM 7.0 EHP3SAP CRM 7.0 EHP3SAP SCM 7.0 EHP4SAP CAR (Customer Activity Repository)Add-On MII 15.1 (Manufacturing Integration andIntelligence) SFM 1.0 (SAP Fashion Management) SAP CAR (Customer Activity Repository) SAP GRC (Governance, Risk, Control) and moreNot yet supported: S/4 Bank Analyzer Industry Solutions Production: POWER8, min 8 core/128 GB For all servers: 96 GB/core max 9 TB LPAR configurated as dedicated ordedicated donating Non-Production: POWER8 or POWER7 , min 2 core No fixed GB/core ratio LPAR configurated in shared processorpoolSAP Note 2218464-Supported products when running SAP HANA on IBM Power Systems24
HoP – Power systems supported25
Hana on Power vs Hana on Intel Sizing comparison Il sizing di HANA è basato sulla memoria (memory driven) Il numero di core è determinato dal rapporto RAM/core stabilito da SAPConfronto tra # core necessari su HoP e HoI a parità di RAM:BWSuite on Hana26
TDI – Tailored Datacenter IntegrationFast ImplementationSupport fully provided by SAPMore FlexibilitySave IT budget and existing investment27
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources28
SAP HANA HA: System Replication – Performance Optimized29
SAP HANA HA: System Replication – Cost Optimized30
High Availability w/o System ReplicationLPAR #1 (AIX)LPAR #2 (AIX)SAP PrimaryApplication ServerHANA DB Client(A)SCS / PASVirt. IPVirt. hostnameSAP (A)SCS(ABAP) Central ServicesLPAR #3 (Linux)SAP HANASystemCluster takeoverSAP HANAVirt. IP/ hostnameCluster takeoverSAP AdditionalApplication ServerHANA DB ClientSAP ERS(Enqueue Replication Server)LPAR #4 (Linux)SAP HANASystem(primary)datalogs31
High Availability and Disaster Recovery Set-UpLPAR #1 (AIX)LPAR #2 (AIX)SAP PrimaryApplication ServerHANA DB Client(A)SCS / PASVirt. IPVirt. hostnameSAP (A)SCS(ABAP) Central ServicesCluster takeoverAIX LPAR #5SAP AdditionalApplication ServerHANA DB ClientSAP PrimaryApplication ServerHANA DB ClientSAP ERSSAP (A)SCS(Enqueue Replication Server)(ABAP) Central ServicesSAP HANAVirt. IP/ hostnameLPAR #3 (Linux)SAP HANASystem(primary)Cluster takeoverLPAR #4 (Linux)SAP HANASystem(standby)LPAR #6 (Linux)SAP HANASystem ReplicationSAP HANASystemAsyncordatalogsStorage Replicationdatalogs32
System Replication vs Storage ReplicationPSXSFull SystemReplicationPEven though automatic failover can be considered as an option, automatic failback should beinhibited: failback can be performed only when data on primary appliance have been realigned from secondary one.33
System Replication vs Storage Replication Cluster LinuxServer HighAvailability VolumemirroringV7000Storage HighAvailabilityV7000HA for “server” based on SUSEclusteringHA for “data” based on storageMetro MirrorServer failover (and failback) doesnot affect dataStorage box failure does not affectserverSUSE Linux cluster: Active / Passive Automatic Failover is possible Standard automation agents forHANA do not support storagereplication Customization of a “standard”automation agent required via adhoc scripts
Migration to HANA on POWER SAP heterogeneous system copyprocedures apply Standard migrations usingSoftware Provisioning Manager(SWPM) and customer R3loadexports Software Upgrade Manager withDatabase Migration Option(SUM/DMO) can be used to combinea release upgrade andthe heterogeneousdatabase migration to anew target system35
SAP High Availability on Linux on Power- Certification of SUSE HA Cluster Official SAP HA Interface Certification forSUSE HA Cluster on IBM Linux on Power Technical Validation successfullycompleted Joint effort of SUSE & IBMSource: https://www.suse.com/products/highavailability/ Support publishedonhttp://scn.sap.com/docs/DOC-31701 SAP note 176351236
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources37
SAP HANA on IBM POWER – Expected Customer Value Intended for mission critical 7 x 24 Enterprise customer operations1.Not an Appliance; Infrastructure Integration2.Highest Reliable, Available, Serviceable (RAS) in the market3.On-Demand Capacity4.Can be integrated into and tailored to a Power customer’s environment ( P7 support),on Power8 servers in production, on Power7 for non-prod environmentsProtect existing customer investments1.Unique PowerVM advantages: Virtualization out of the Box2.HANA Tailored Datacenter approach re-use existing IT assets and operational patterns3.Create LPAR from existing, instead of purchasing a dedicated appliance4.More granular and flexible CPU (Core) and memory increments possible5.in-box co-existence with established SAP landscape using AIX, IBM i38
HoP is Aligned to HANA Standards From a coding and software manufacturing angle IBM Power Systems andLinux on POWER distributions are a mainstream HANA developmentplatform with comparable SAP solution support as Intel platforms. As such, we adhere to and comply with identical HANA system KPIrequirements, tools and processes defined by SAP SE: SAP HANA Quicksizer and SAP DB sizing tools SAP application and sizing related documentation SAP tools like QuickSizer, Hardware Configuration Check Tool (HWCCT) etc. Customer defect support and services offerings follow established SAPand IBM processes and organizations can leverage the new SAP HANA „single point of contact“ strategy with end-toend support from IBM.39
ContentSAP HANA – Brief overviewHANA on Power – History and current stateComparison Power vs x86 platformsHANA Sizing and SupportOperational ConceptsSummary on customer valuesSummary and information sources40
First HoP Reference CustomerTUM – Technical University of Munich41
First MSP/CSP to acquire Power for a TDI implementationAbout CTAC:CTAC is an ICT Solution Provider developing and implementing industry-tailored solutions for their customers’ businessprocesses in a variety of markets. The comprehensive industry-specific solutions for retail, wholesale, real estate andcharity, among others, were developed in collaboration with customers, based on standard software from market leaderssuch as SAP, Microsoft and other well-known technology suppliers.POWER8 & V7000 WIN!Industry: IT Solutions ProviderWinning Solution:2 x E870 Power Systems40-Core, 3TB Memoryeach with 42TB of V7000storageCompetition: x86CTAC has been complementing industry-specific composed solutions with a full service package, ranging from businessconsultancy to managed services, and software development to innovative services such as mobility, in-memorycomputing and cloud for over 20 years. Headquartered in Hertogenbosch, in the Netherlands, CTAC also operates inBelgium and France. http://www.ctac.nl/Background and business needs:CTAC offers a range of solutions based on SAP software through their cloud hosting environment. Before theannouncement of HANA TDI (Tailored Datacenter Integration), CTAC could only offer static x86 appliances. Thus, theyexplored the option of building a SAP TDI environment for SAP HANA workloads. In order to host this environment, CTACwas looking for a cost effective platform to deliver the requested performance, scalability and availability.Solution:CTAC decided to build the new SAP HANA TDI cloud based on a solution running IBM Power Systems and StorwizeV7000 storage to meet their requirements. They will host virtualized SAP HANA environments running SUSE Linux on IBMPower E870 Systems. Storage requirements for SAP HANA TDI will be delivered by IBM V7000 systems using acombination of SSD and SAS disk drives. Management tooling include IBM PowerVC and Spectrum Virtualize toefficiently run and monitor the environment. For the initial set-up CTAC acquired two 40-Core, 3TB Memory E870 PowerSystems each with 42TB of V7000 storage.Reference Video: https://www.youtube.com/watch?v QuLS6y3QGeo42
First HANA on POWER Winback from x86About Hamm Reno Group:Hamm Reno Group is the largest shoe retailer in Europe with more than 750 stores and is represented in 20 countries.Hamm Reno Group has both top brands as well as a wide assortment of fashionable footwear for the whole family in itsportfolio.http://www.hr-group.de/POWER8 WIN!Industry: RetailBackground and business needs:Hamm Reno Group has been a long time IBM Power customer running traditional SAP workload on Power. As early as 2012,they installed SAP HANA on two IBM X5 SAP HANA appliances. When their SAP HANA appliances lease was expiring inNovember 2015 they started looking for a new solution. As they were informed of SAP HANA on IBM Power Systems inMarch 2015, and the upcoming Ramp Up program for SAP HANA on Power Systems, they became highly interested in thisoffering. The IBM team seized the opportunity to integrate and migrate their SAP Business Warehouse (BW) SAP HANAinstallation based on x86 Lenovo to IBM POWER8 which is the main platform for Hamm Reno Group’s SAP workload.The solution addressed Hamm Reno Group’s concerns on the lack of flexibility and virtualization with SAP HANA on thecurrent platform.Winning Solution:1x POWER8 S822L, 20Cores,512 GB RAM3 x POWER8 S824, 24 Cores,768 GB RAMSAP Solution Manager andSAP SLTSolution: 1 x S822L Power Server for production SAP HANA instance (SAP HANA DB: 320 GB, 10 cores) 1 x S824 Power Server fully virtualized for Test and Development SAP HANA (256 GB) additional SAP workload (ERP,HCM, SRM) Existing V5000 with HDD and SSD integrated with POWER8 servers for data and logs SUSE Linux SLES 11 SP3 and TSM for ERP backup solution.Hamm Reno Group is the first customer to use TSM for ERP on LoPCompetition: Lenovo (x86based SAP HANA Appliance)Benefits of the solution for Hamm Reno Group: Virtualized SAP HANA workload providing both flexibility and scalability while optimizing system utilization and reducinginfrastructure
SAP Business Warehouse SAP NetWeaver BW version 7.31 or higher Scale-Up and Scale-Out (multi-host) up to 16x 4.8TB nodes ( 76TB) SAP BPC 10.1 (in Controlled Availability) SAP BO BI 4.1 SAP Hana Dynamic Tiering (SPS 11) Production: POWER8, min 8 core/128 GB Server S82X e E850: 32 G
SAP ERP SAP HANA SAP CRM SAP HANA SAP BW SAP HANA SAP Runs SAP Internal HANA adoption roadmap SAP HANA as side-by-side scenario SAP BW powered by SAP HANA SAP Business Suite powered by SAP HANA Simple Finance 1.0 2011 2013 2014 2015 Simple Finance 2.0 S/4 HANA SAP ERP sFin Add-On 2.0
c. SAP HANA Rules Framework; d. SAP HANA, data privacy option; e. SAP HANA, predictive option; f. SAP HANA, spatial and graph option; g. SAP HANA, search and text option; h. SAP HANA, Smart Data Quality ("SDQ "); i. SAP Smart Data Integration ("SDI "); and j. SAP HANA, native storage extension. 3.2. SAP HANA Platform includes the HANA Studio .
Customer Roadmap to SAP Simple Finance - Example " Adopting SAP Simple Finance is a journey - start early" Side-by-side SAP HANA Acceleration SAP HANA accelerators, BW, BPC, GRC SAP Business Suite on SAP HANA SAP ERP on SAP HANA SAP ERP in SAP HANA Enterprise Cloud SAP Accounting Powered By SAP HANA Simple Finance add-on/
1. Introduction: SAP Solution Manager and SAP HANA 2. How to connect SAP HANA to SAP Solution Manager? 3. Monitoring of SAP HANA via SAP Solution Manager 4. Doing Root Cause Analysis of SAP HANA with SAP Solution Manager 5. Extend your Change Control Management towards SAP HANA 6. Even More Valuable Features of SAP Solution Manager
SAP PowerDesigner, Enterprise Architecture Designer SAP HANA Web IDE SAP HANA smart data integration and SAP HANA smart data quality SAP HANA extended application services information management option SAP HANA . SAP HANA Vora HANA-optimized re .
SAP NW 7.4 SAP BW 7.4 SPS12 SAP BPC 10.1 RHEL 6.6x SAP HANA SP10 SAP NW 7.5 SAP ECC 6 EHP8 SAP Portal/SolMan RHEL 6.6x SAP HANA SP11 S/4 HANA SAP Fiori BI on HANA BW Simplification HANA Journey –Client Example
SAP HANA supports the following DDR4 DRAM memory configurations: SAP HANA 2.0 memory up to 2 TB for SAP NetWeaver Business Warehouse (BW) and DataMart. SAP HANA 2.0 memory up to 4 TB for SAP Business Suite on SAP HANA (SoH) Operating system The Cisco X210c M6 server is certified for SAP HANA starting with the RHEL for SAP Solutions 8.2
To install SAP HANA Studio, see the SAP HANA Studio Installation Guide. Many administrative functions are provided by SAP HANA Studio. Follow the instructions available in the SAP HANA Administration Guide and the SAP HANA Server Installation and Update Guide, as needed. For more information, see "References on page 19." SAP HANA Cockpit
