1 / 24

IBM FlashSystems and IBM Power Systems for SAP landscapes

IBM FlashSystems and IBM Power Systems for SAP landscapes. Maik Gasterstaedt, SME Storage ISICC Matthias Koechl, SME Power Systems ISICC. Content. IBM Flash Technology and Products. IBM FlashSystems in SAP Landscapes. Reference Architectures and Use Cases. First Customer References .

vanna
Download Presentation

IBM FlashSystems and IBM Power Systems for SAP landscapes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IBM FlashSystems and IBM Power Systems for SAP landscapes Maik Gasterstaedt, SME Storage ISICC Matthias Koechl, SME Power Systems ISICC

  2. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  3. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  4. IBM Flash Systems: 4 choices today All units 1U form factor, less than 500 Watts

  5. Comparison of Flash Storage and other storage technologies Higher costs per capacity Lower costs per IOPS IOPS are very important in all SAP sizing considerations and main reason for lack of performance at many real SAP customer installations

  6. Overall benefits of IBM FlashSystems • Higher performance and lower costs per TB compared to SSDs • Best price/performance ratio for high I/O workload requirements versus HDD and SSD • Energy savings (no rotating disks) • Integrates and extends seamlessly with existing technology (IBM and non IBM) • SVC for convenient management and enhanced enterprise functionality:easy tier, space efficient backups and clones, stretched cluster, mirroring acceleration • AIX LVM mirroring: supports AIX native ultra fast mirroring across multiple storage devices • AIX VIOs shared storage pools

  7. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  8. For SAP and other business critical applications we recommend: Model 820 (capacity) or Model 720 (durability) both covering HA Very high durability reasonable capacity high durability high capacity Higher Capacity Better HA All units 1U form factor, less than 500 Watts

  9. IBM FlashSystem Choices Right for BusinessCritical Apps • For typical SAP Business Suite landscapes we recommend IBM FlashSystem 820 for the following reasons: • Availability: Enterprise critical business data are contained on device and secured by RAID • Durability vs. $/TB: SAP application typical read/write ratio 80/20 • Capacity: Model 820 provides max. capacity • One exception might be to store data with many refresh cycles in short time periods : • IBM FlashSystem 720 for write intensive IO – overwrite entire capacity at least twice a day, e.g. as used in LOG files of SAP databases • Note: at 1 GB/s sustained write degradation of the 5TB FlashSystem 720 is 17.43 years 9

  10. Main benefits of IBM FlashSystems in SAP landscapes Enterprise Array, No FlashIBM FlashSystems • 2 million SQL queries • 12.25 minutes to complete • 16K Total IOPS • 4K per DB Node • 2 million SQL queries • 1.3 minutes to complete • 160K Total IOPS • 40K per DB Node 10x faster • Faster DB access • Improve SAP server efficiency due to significantly reduced I/O wait cycles • Omit performance bottlenecks because of poor IO operations • Simply to introduce: “Plug & Play” of new FlashSystems devices without architectural changes to applications or infrastructure • No cost intensive migration to in-memory DB to speed- up SAP batch runs

  11. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  12. Typical use cases for IBM FlashSystems: SAP BW (OLAP queries) Pros: • BW queries are read mostly • Database is mirrored over IBM FlashSystem and IBM storwize and traditional storage • Use AIX LVM mirroring for HA purposes • Gain performance increase through preferred reads from FlashSystem • Costs can be saved by using traditional storage as mirror devide • Easy to implement, can be done online Cons: • Writes delays because data to be written to FlashSystem AND tranditional storage IBM Power with AIX LVM mirroring Traditional SAN Preferred Read IBM FlashSystem 820 IBM Storwize BW / OLAP queries benefit from 10x faster sequential read

  13. Typical use cases for IBM FlashSystems: High frequently accessed OLTP databases Pros: • Use AIX LVM mirroring for HA purposes • Additional applications running on the same host can be placed on traditional storage • Gain full advantage of FlashSystem read AND write performance • Easy to implement Cons: • Limited capacity • More expensive because two FlashSystems are required for DR purpose IBM Power with AIX LVM mirroring Traditional SAN IBM FlashSystem 820 IBM FlashSystem 820 • High frequently accessed transactional business data completely place on IBM FlashSystem 820

  14. Typical use cases for IBM FlashSystems: Acceleration of OLTP load Pros: • Speedup of write I/O intensive, e.g. redo log files, workload on FlashSystems • Use AIX LVM mirroring for HA purposes • Gain advantage of FlashSystems write performance • Easy to implement • Capacity enhanced by using traditional storage • Cost savings by using heterogenous storage devices Cons: • Limited flexibility to shift workload between different storage classes IBM Power AIX LVM mirroring Traditional SAN IBM FlashSystem 720 IBM FlashSystem 720 IBM Storwize or XIV IBM Storwize or XIV • Accelerate OLTP processing and placing redo logs and DB temp on IBM FlashSystem 720

  15. Typical use cases for IBM FlashSystems: Smart distribution of data “Hotspots” Pros: • Use SVC stretched cluster for HA purposes • Gain advantage of FlashSystem write performance • FlashSystem easy to integrated • Capacity enhanced by using traditional storage • Enhance read and write performance of traditional storage by using EasyTier(parts of FlashSystem can be utilized as high performance tier) • Cost savings by using heterogenous storage devices • Full flexibility to shift workload between different storage classes Cons: • More complex scenario • Higher initial implemantation costs IBM Power Preferred read on local site IBM SAN Volume Controller EasyTier switched on IBM SAN Volume Controller EasyTier switched on SCV stretched cluster Short disctance (10 km) to avoid latency logs only SVC cache disabled! IBM FlashSystem 820 IBM Storwize or XIV IBM FlashSystem 820 IBM Storwize or XIV • SAP Business Suite distributing DB Hotspots OLTP, pinned portions (e.g. logs) and autonomously managed with EasyTier mechanism

  16. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  17. Proof points: Speedup in SAP ERP Batch runs and backup/restore operations with/without IBM FlashSystems • Customer: Stuttgarter Straßenbahnen AG • SAP service provider • Database: Oracle • Servers: IBM Power Systems running on AIX • Storage architecture: uses SVC stretched cluster 2h 5h 48h 6min 40min 8h

  18. RamSan Customer Reference with SAPnote: RamSan was former name of IBM FlashSystems Speedups: between 1.5 and 13.4! SAP • Customer: Vaillant GmbH & Co. KG • Internal SAP landscape • Database: Oracle • Servers: HP integrity running on HP/UX • Storage architecture: SAN attached RamSan Oracle HP integrity with HP/UX 11.2 SAN

  19. PoC at customer ABB: Initial situation Current SAP landscape: • 15 major manufacturing plants all running and dependent on SAP business applications • SAP users: 7,500 • Servers: IBM Power Systems / AIX • Storage Systems: IBM DS8700 (data mirrored between 2 data centers) Customer pain points: • SAP User unsatisfied with current SAP performance • Delays in month-end batch reads and reporting • Dialog response times approaching business SLAs • Performance concerns because of hesitation to invest in growth Alternative tested to improve situation: • Additional CPU => Limited improvements with additional cost • SAP dedicated SAN => Too expensive • DS8700 SSD => Too expensive and configuration limitations • SAP / Oracle tuning => Limited changes helped a little, extensive changes, too labor intensive • SAP HANA => Unproven; insufficient app team cycles

  20. PoC at customer ABB: The solution with IBM FlashSystems Technical Implementation: Migrate the prime database and logs to 2x 6TB IBM FlashSystem Model 810 Position the 810s behind the existing SVC clusters Mirror LUNs between 810s at the host level Benefits of IBM FlashSystem solution: Quantitative performance target: 213% improvement because of less CPU Near price parity with DS8700 disk Fully SVC compliant allowing for transparent migration No changes to existing production environment required Full integration with existing Tivoli monitoring via SNMP Results: Initial testing on QR showed 35% latency improvement Month-end batch runs expectations => 464% improvement CPU reductions to be tested soon (potential more cost savings) ABB is now a reference account for IBM FlashSystems New multiple SAP growth projects underway

  21. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  22. Summary of benefits • IBM FlashSystem eliminates I/O bottlenecks, providing the lowest latency of any SAN-based storage solution with IBM MicroLatency™. • Very high customer acceptance in all projects so far • No risk for implementation into productive infrastructure • Boost performance without any change of software stack • Boost performance without any change of Storage architecture, i.e. without any feature loss (data mirror, system management, backup/restore capabilities) • Fully SVC compliant allowing for transparent migration • Full integration with existing Tivoli monitoring via SNMP • IBM Power Systems I/O using LVM mirroring can link to operational data and flash storage paths to accelerate the I/O intensive workloads. • IBM FlashSystem is a perfect fit for “small and big” SAP landscapes • IBM FlashSystem is cheaper than SSD, $ per TB • IBM FlashSystem provides the right capacity for SAP landscapes • IBM FlashSystem is a proven technology, fastest external Flash Storage System on the Market

  23. Content IBM Flash Technology and Products IBM FlashSystems in SAP Landscapes Reference Architectures and Use Cases First Customer References Summary of Benefits Sales Tools

  24. Additional information and tools WW STG Storage Solutions for SAP – Sales & Technical Sales Enablement IBM FlashSystems Sales Kit IBM FlashSystems TechSales Community IBM FlashSystems Performance IBM FlashSystems Demonstration/Development and Evaluation Program (Oracle AWR report analysis) Further information: Mailto ISICC@de.ibm.com

More Related