sap hana on ibm power 8
TRANSCRIPT
SAP HANA on IBM Power Systems
Florence Guiot-Roux [email protected] 06.84.53.35.70
Supported databases by SAP Business Suite
2
Database Remarks
DB2 LUW It provides in-memory technology (feature BLU), row +
column store and very high compression (BW only)
DB2 for IBM i Only available from IBM in combination with Power
Systems.Very high acceptance at installed base.
DB2 z/OS Highest degree of RAS. High acceptance at installed
base.
MS SQL Server
Oracle
Oracle Extended License Package Extension e.g. to run Oracle RAC
SAP MaxDB No further development
SAP Sybase ASE Runtime Announced for SAP BS after having introduced HANA
SAP HANA Many different price metrics
Today and up to 2025 for current offering
SAP on In-Memory Computing: Re-think Paradigms
3
In-Memory Computing Imperative: Avoid movement of detailed data Calculate first, then move results
Application
Layer
Database
Layer
Calculation
Calculation
Today Future
SAP HANA (formerly High Performance Analytics Appliance)
• An in-memory Database– column oriented
– compressed
– most beneficial for OLAP read queries
• An „Appliance“ ???– standardized and certified solution
stacks deployable on selected Intel based servers
– available only on Linux/Intel servers
– HEC � HANA Enterprise Cloudsubscription based cloud services
– TDI � tailored data-center integrationre-use existing IT assets (storage)
• A Platform– SAP Analytics and ERP applications
– Non-SAP environments
4
POWER8
SAP HANA (formerly High Performance Analytics Appliance)
• An in-memory Database– column oriented
– compressed
– most beneficial for OLAP read queries
• An „Appliance“ ???– standardized and certified solution
stacks deployable on selected Intel based servers
– available only on Linux/Intel servers
– HEC � HANA Enterprise Cloudsubscription based cloud services
– TDI � tailored data-center integrationre-use existing IT assets (storage)
• A Platform– SAP Analytics and ERP applications
– Non-SAP environments
5
SAP HANA on POWER – the story
November 2014 – February 2015
Release to Customer Ramp-Up Start
April 2015
Public announcement
at SAPPHIRE, May 2015
Ramp-Up period
BWoHoPCustomer Test and Evaluation phase
TE period SoH@HoP
selected use cases
Closed 11/15
GA dateSoH
(ERP, SRM, CRM)
November.2015
General Availability HANA on POWER with use case BW
August 2015
Ramp-Upperiod
BWoHoPClosed 07/15
IBM is a multi-faceted SAP Partner
• All Platforms Certified for SAP – over 41,000 installations
• All Platforms Deliver Lowest possible TCO for SAP
• Large Investment in Optimizing SAP Environments
• IBM Achieved Proven Low Risk for SAP Installations
• HANA – on IBM Power• # 1 SAP SD Benchmark
• SAP’s Premier Preferred HANA Cloud Provider
• Global Alliance partner since 1989• Over 26,000 SAP-focused resources in 160
countries• Dedicated HANA practice• Rated #1 System Integrator by Gartner, AMR,
Aberdeen• #1 in SAP upgrades• AMS services
• SAP Cloud Solutions are integrated with IBM’s Cloud tools
• IBM Spectrum SAP HANA certified
• Integrated System Management with SAP LVM
• Cheaper, better, faster!
• IBM’s Internal SAP implementation• Will provide common global processes
across IBM SAP• Driving interoperability between SAP
and IBM SW• IBM and SAP Consulting partnered to
provide implementation services• Proven IBM technology infrastructure
C U S TOM E R
Power Systems S812L
• 1-socket, 2U• Up to 12 cores
• 2-socket, 2U• 1 TB memory
•2-socket, 2U•Up to 20 cores
Power Systems S822
Power Systems S814
•1-socket, 4U•Up to 8 cores
Power Systems S824, S824L
•2-socket, 4U•Up to 24 cores
8
Power Systems S822L
Power Systems E870/E880
•4-sockets per Drawer•Up to 64 / 80 (128 / 192 cores 32 TB )
Mutiple OS: supported => consolidate heterogeneous workload
Virtualization: PowerVM or KVM Linux => TCO, Security
Advanced technology:
POWER8 conception => Performance, TCO
AME, AMS : Active memory expansion and sharing => TCO
CAPI: Coherent attach processor interface => Performance, TCO
LPM & PEP: Live partition mobility & Power enterprise pool => Flexibilty
RAS: Reliability Avalaibility Servicability => TCO
Scale Out or Scale In
Power SystemsE850
Power Systems S822LC
Power Systems S812LC
From 256 GB
To 32 TB
Brief overview of the added value on Power 8 Systems family
Why is Power THE SAP HANA platform
Performance
Resilience and security
Flexibility
� The only alternative choice to x86
Strategy - Innovation
10
IBM is a real alternative to x86 …
IBM is serious about Open and innovation
The Ecosystem is growing:OpenPOWER Summit Hardware Announcement (Mar. 2015)
More details available at http://openpowersummit2015.tumblr.com/factsheet
Chuanghe 1S/1U POWER8 server
Collaborators: Chuanghe Cirrascale RM4950
Collaborators: Cirrascale, NVIDIA
Virtex 7 CAPI-based Adapter Kit
Collaborators: Convey, Xilinx
TYAN TN71-BP012
Collaborators: Tyan, Mellanox
IBM Memory Technology Innovation Utilizing
Altera FPGAsCollaborators: IBM, Altera
IBM 2U/2S POWER8/NVIDIA GPU Server “Firestone”
Collaborators: IBM, Wistron,NVIDIA, Mellanox
Inspur 2S/2U server
Collaborators: InspurMellanox ConnectX-4 CAPI-adapter
Collaborators: Mellanox
Open server specification and Open
Compute motherboard mock-upCollaborators: Rackspace
Suzhou PowerCore CP1 mechanical sample
Collaborators: POWERCORE
Zoom 2S/2U POWER8 System Planar &
Memory RiserCollaborators: Zoom Netcom, Byosoft, Unisource
Power8 = Performance
5500 SAPS / core !!!
� Less cores, less footprint,
� Less by core licencing
� Simpler administration
� Better TCO
Power8 = Resilience and security
� Unsurpassed RAS (reliability, availability, serviceability) characteristics to support mission critical SAP applications (eg. Fault Isolation Register, FFDC&C, built checkers pour detection des erreurs HW …)
� Intended for mission critical 7X24 Enterprise customer operations
� Memory built for resiliency and performance
� ZERO security breeches for PowerVM
Power8 = Flexibility
Virtualization “out of the box” with PowerVM
� Implemented as a Tailored Data Center Integration (TDI) offering (not an appliance)
� On-Demand Capacity
� Can be integrated into and tailored to a Power customer’s environment
� Superior virtualization and management features to afford flexibility and maximum utilization
� Lower virtualization layer overhead on multi-threaded HANA workloads
� Value: fewer cores, fewer footprints, and lower operating costs
• IBM Systems Lab Services has experienced consultants
worldwide ready to help clients deploy solutions for SAP
HANA systems
• Lab Services installations leverage trusted best practices
and deep experience of Linux on Power performance,
infrastructure optimization and resiliency planning
• Provide the installation of the solution up to the HANA
software level
IBM Systems Lab Services and SAP HANA
16 This is the current state of planning and may be changed by SAP at any time.
17
More than 80 SAP HoP Customers in the world in a few months !
NTT DATA : "Our internal testing has shown that SAP reports run
significantly faster when using SAP Hana on Power," said Bhala Bhosale, senior vice president of Enterprise Services. "Queries that took an hour to run can now be completed in just minutes."
https://www.youtube.com/watch?v=GbUvMKINwF0
Technische Universität München meet customer expectations with SAP HANA on IBM POWER8 (S822 and XIV® Storage) . SAP HANA on IBM POWER8 gives Technishe Universität München the ability to run the way their customers need them to: Fast, simple and smart
https://www.youtube.com/watch?v=APYbZ8-kv8A
Hamm Reno Group:Virtualized SAP HANA workload providing both flexibility and scalability while optimizing system utilization and reducing infrastructure and related costs. Homogeneous POWER8 infrastructure for complete SAP landscape
CTAC: first MSP/CSP to acquire Power System E870 and Storwize V7000 for SAP HANA TDI infrastructureSAP HANA TDI cloud based solution to meet their requirements. Virtualized SAP HANA environments running SUSE Linux on IBM Power E870 Systems. Management tooling include IBM PowerVC and Spectrum Virtualize to efficiently run and monitor the environment https://www.youtube.com/watch?v=QuLS6y3QGeo
https://www.youtube.com/watch?v=fhm0YAUsrOI
In short, IBM Power Systems is the best platform for your mission critical SAP HANA deployments
• Performance
– Highest throughput per core to deliver faster business results
– More than 2x Intel-based alternatives
– Significant Power SMT-8 throughput advantages
• Resiliency
– Unsurpassed RAS (reliability, availability, serviceability) characteristics to support mission critical SAP applications
– Intended for mission critical 7X24 Enterprise customer operations
– Implemented as a Tailored Data Center Integration (TDI) offering (not an appliance)
– Highest Reliable, Available, Serviceable (RAS) in the market
– On-Demand Capacity
– Can be integrated into and tailored to a Power customer’s environment
• Flexibility
– Superior virtualization and management features to afford flexibility and maximum utilization
– Lower virtualization layer overhead on multi-threaded HANA workloads
– Value: fewer cores, fewer footprints, and lower operating costs
Impacts on HW Infrastructure moving towards SAP HANA
19
Any DB/
Any OS
APP APP APPAPP
An
y O
S
HANA / Linux
HANA migration
No Changes
� At frontends
� At application server
infrastructure
=>
� Re-use of available
application servers
� Sizing of application
servers remains
valid
Frontends
Application Servers
Changes
� New infrastructure
mandatory to run SAP
HANA
� Different sizing for
HANA infrastructure
� Migration of database
to SAP HANA required
Partly necessary
� Data model adoptions
� Custom extensions
HANA on Power ���� AS and DB in the same physical server
20
SAP TDI (Tailored Datacenter Integration) for HANA
• Solution validation done by SAP and partner• Preconfigured hardware set-up• Preinstalled software
• HANA IT provided by customer• Storage requires generic TDI approval by SAP• Individual performance KPIs verified per customer• partner individual support model
Fast ImplementationSupport fully provided by SAP
More FlexibilitySave IT budget and existing investment
HANA on POWER is „TDI-level4“
SAP HANA on IBM Power (Status: 04/2016)SAP HANA on IBM Power supports: • SAP ERP 6.0 EHP7+8• SAP SRM 7.0 EHP3+4• SAP CRM 7.0 EHP3+4• SAP SCM 7.0 EHP4• SAP BW 7.31, 7.40, 7.50, BI JAVA 7.40 for SAP HANA• and a lot of other products on HANA on Power
(e.g. BPC 10.1, SAP BO BI 4.1 SP03, CAR 1.0 SPS03, MDG 7.0, Banking 9.0, SolMan 7.2, SLT 2.0, SDI 1.0 SP02 etc.)
Core to Memory ratio (per productive HANA LPAR): – higher ratio potentially on individual request@SAP
• BW • 50 GB per core on E880 (max. 96 cores; at most 4800 GB RAM) • 50 GB per core on E870 (max. 80 cores; at most 4,0 TB RAM) • 32 GB per core on E850 (max. 32 Cores) and S-models
• SAP Business Suite (SoH: Suite on HANA)• 96 GB per core• at most 9 TB RAM
• Minimum core count per productive LPAR is 8 cores, non-productive LPAR is 2 cores
BW Scale-Up & Scale-Out (xfs 16x 4800 GB)
SoH Scale-Up
http://service.sap.com/sap/support/notes/2218464
http://service.sap.com/sap/support/notes/2188482
22
SAP HANA on IBM Power (Status: 04/2016)Multiple HANA LPARs supported for production on a single server: up to 4 dedicated or 3 dedicated and 1 shared pool
Support for Clustering Support - HANA BW Scale-out (xfs, up to 16 nodes / up to 4800 GB each)
HANA SPS11 Platform Edition availability for POWER (at the same time as with x86)
Non-Production relaxations of the requirements for SAP HANA on IBM Power Servers• POWER8 and POWER7+ servers allowed• No restrictions with regards to the maximum memory per HANA LPAR core• The minimum core count per HANA LPAR is 2.• HANA LPARS can be run in a shared processor pool running with a performance penalty• Standard Network Components are admitted.• SAP HANA LPARS for test, development and quality assurance systems may run in parallel to
other LPARs (for SAP HANA or other purposes) on a single physical Power Server as long as none of the participating LPARs runs a production SAP HANA system.
• Besides xfs also NFS, GPFS and ext3 filesystems are supported.
23
04/2016: Allowed Hardware for SAP HANA on IBM Power
25
Source: SAP SE
SuSE integration
27
Power Systems S812L
• 1-socket, 2U• Up to 12 cores
• 2-socket, 2U• 1 TB memory
•2-socket, 2U•Up to 20 cores
Power Systems S822
Power Systems S814
•1-socket, 4U•Up to 8 cores
Power Systems S824, S824L
•2-socket, 4U•Up to 24 cores
Power 8 Systems family for SAP HANA
28
Power Systems S822L
Power Systems E870/E880
•4-sockets per Drawer•Up to 64 / 80 (128 / 192 cores 32 TB )
Mutiple OS: supported => consolidate heterogeneous workload
Virtualization: PowerVM or KVM Linux => TCO, Security
Advanced technology:
POWER8 conception => Performance, TCO
AME: AMS Active memory expansion => TCO
CAPI: Coherent attach processor interface => Performance, TCO
LPM & PEP: Live partition mobility & Power enterprise pool => Flexibilty
RAS: Reliability Avalaibility Servicability => TCO
Scale Out or Scale In
Power SystemsE850
Power Systems S822LC
Power Systems S812LC
ALL Power systems are certifiedfor use with SAP on RDB
AS only
AS only,
HANA DB later
AS and HANA DB
From 256 GB
To 32 TB
Migration to HANA on POWER
• SAP heterogeneous system copy
procedures apply• Standard migrations using
Software Provisioning Manager (SWPM) and customer R3load
exports
• Software Upgrade Manager with Database Migration Option
(SUM/DMO)
– can be used to combine a
release upgrade and the
heterogeneous database
migration to a new target system
29
HANA on POWER Technical Manuals
• Planning Guide
–ready for 2014 TEA and 2015 Ramp-Up phase
–features Process/Support/Service guidance
• IBM Supplemental HoP Implementation Guide
–Being created now
–Planned final version for HoP GA
• Administration/Troubleshooting Guide
–Future plan
–Includes best practices from customer production sites
30
Map SAP Sizingresults to IBM HoP specifics
Supplemental to SAP HANA
Master, Installation & Admin Guide
Important SAP Notes
The SAP Support Portal contains SAP Notes detailing solutions for known problems or providing additional information
• SAP Note 2133369 SAP HANA on Power: Central Release Note (includes a scope document as attachment!!!)
• SAP Note 2055470 SAP HANA on POWER planning and installation specifics - central note
• SAP Note 2130682 SAP HANA on Power Documentation for Ramp-Up
31
32