1 / 39

Oracle Optimized Solution for SAP

Oracle Optimized Solution for SAP. Ken Kutzer.

xia
Download Presentation

Oracle Optimized Solution for SAP

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. Oracle Optimized Solution for SAP Ken Kutzer

  2. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

  3. Agenda • Oracle Optimized Solution for SAP • Solution Architecture • Real World Results • Q and A

  4. Oracle and SAP Partnership Database Market Share for SAP For the Benefit of our Mutual Customers All Others • Business partners for 20+ years • SAP is the largest Oracle database reseller • SAP expertise in Oracle • SAP Competency Center in Waldorf Germany • SAP architects in presales organization • Oracle Solution Center • SAP sizing and customer proof-of-concept testing • Oracle Advanced Customer Services and Consulting for SAP Oracle

  5. Joint Technical Efforts For the Benefit of our Mutual Customers • Joint engineering work • Integration, version alignment, patching • Certification of Engineered Systems, software products and hardware products • Conduct high performance benchmarking • Joint customer support • Dedicated SAP experts Oracle support organization • Escalation path from SAP to Oracle or Oracle to SAP as appropriate

  6. Improving SAP Environments Integration, Service and Support Managed by Customer Oracle Approach Traditional Approach vs.

  7. Traditional SAP Landscape Deployment Sprawl Develops Over Time SAP ECC SAP PLM DEV DEV Employees SAP ECC Employees QAS PRD SAP PLM Partners QAS PRD Storage Systems Partners SAP SCM SAP SCM SAP HR SAP HR DEV Vendors DEV Vendors QAS QAS Customers Customers PRD PRD

  8. Oracle Optimized Solution for SAP Consolidation and Simplification for SAP Environments • Best performance • Run queries up to 7x faster • Perform data loads 4x faster • Rapid deployment • 4x faster to time to production • Reduce risk • Full SAP and database High Availability • Pre-built, optimized, and validated architecture for SAP SAP OracleDatabase Oracle Enterprise Manager Oracle Solaris Oracle Solaris Zones Oracle Solaris Oracle SuperCluster See substantiation slides

  9. Overview of Oracle SuperCluster

  10. Oracle SuperClusterOracle Optimized Solution for SAP • Engineered System for database and application consolidation • Integrated High Availability • Optimized to run complex multi-tier SAP environments • Ideal platform for the deployment of Oracle Optimized Solutions • Half rack, full rack and multiple rack configurations

  11. Management Framework Unified Apps to Disk Management UnifiedManagement Synchronized Update of All Components Telemetry

  12. Accelerate and Simplify SAP Deployments Easy, Predictable, Just Works Cut Deployment Times by up to 4x High Availability Built in 99.999% Uptime 100’s of Components  1 Machine 1000’s of Hours  1 Day

  13. Oracle SuperCluster Support for SAP SAP Support Since March 2012 • SAP NetWeaver 6.4 or 7.0+; JAVA and ABAP Applications • SAP Note 1693680: Running SAP Software on Oracle SPARC SuperCluster • SAP Note 1696570: OracleSPARC SuperCluster:Patches for 11.2.0.3

  14. New! Oracle SuperCluster T5-8 • Powered by the Oracle SPARC T5-8 - #1 performance for Database, Java, middleware, ERP, CRM etc. • ~2.3x improvement in compute performance per rack • 33% more Exadata Storage Servers • Dramatic improvement in price performance

  15. New Record! SPARC T5-8 Server Delivers Best Eight-Chip, Two-Tier SAP SD Standard Application Benchmark Result! Oracle SPARC T5-8 server with 8 processors, 128 cores and 1024 threads delivers result with 40,000 SAP SD users or 220,950 SAPS Results as of March 26,2013. Source: SAP, www.sap.com/benchmark. The SAP Two-tier SAP Sales and Distribution (SD) standard SAP ERP 6.0 2005/EP5 application benchmarks on March 26, 2013, by Oracle, has been certified with the following data: 40,000 SAP Two-Tier SD Users, 220,950 SAPs for SAP Two-Tier SD. Server configuration: SPARC T5-8 (8 processors, 128 cores, 1024 threads, T5, 3.6 GHz), 2 TB main memory, Oracle Solaris 11, Oracle Database 11g Release 2, and SAP enhancement package 4 for SAP ERP 6.0. Certification Number: Certification Number: 2013008.

  16. Key SuperCluster Technology Advantages • Oracle Real Application Clusters • Delivered leading SAP SD benchmark: 180K users, 1M SAPS* • Exadata Storage Servers • Proven technology that reduces database response times • InfiniBand “backplane” – connection between nodes and Exadata • Very low latency, 40 Gb/sec connections improves performance • Oracle Solaris Zones • Virtualization technology for optimal SAP consolidation • Oracle Solaris Cluster • Provides High Availability for SAP Central Services and optionally for application servers *Results as of September 1, 2012. Source: SAP, www.sap.com/benchmark, the SAP SD-Parallel standard application benchmark performed on September 5, 2011, by Oracle: 180,000 SAP SD-Parallel benchmark users, 1,016,380 SAPS, Server configuration: 8 Sun Fire X4800 servers each with 8 processors/80 cores/160 threads, Intel Xeon Processor E7-8870, 2.40 GHz, Solaris 10 operating system, Oracle Database 11g Release 2 with Oracle Real Application Clusters, and SAP enhancement package 4 for SAP ERP 6.0. Certification Number: 2011037

  17. Oralce SuperCluster Testing with SAP Global Engineering Cooperation • Oracle - Santa Clara (primary SuperCluster development center) • Experts for SuperCluster, Oracle Solaris Cluster, Oracle Database, SAP, Benchmarking • Large scale testing and modeling • Oracle Competency Center – Walldorf • SAP expertise and center for engineering collaboration with SAP • Ongoing SAP testing of new releases and features • Same expert team driving work at both sites

  18. Deploying SAP on SuperCluster

  19. Solution Architecture Overview 10 GbE Data Center Network SuperCluster Node 1 Node 2 App Domain App Domain • SAP runs in App Domain • HA for SAP Central Services and Application Instances via Oracle Solaris Cluster • Exadata Storage/RAC for database scaling and HA • ZFS Storage Appliance for shared SAP binaries, configuration and other log files • IB for ultra low latency interconnect Oracle Solaris Oracle Solaris DB Domain DB Domain Oracle Solaris 11 Oracle Solaris 11 InfiniBand Network Oracle ExadataStorage Servers

  20. High Availability for Production Landscape Cluster Node2 Node1 App Domain App Domain • Oracle 11g with RAC in DB domains • Oracle Solaris Zone Cluster in App Domains • System Central Services (SCS) • Message Service • Enqueue Service • Gateway (Java) • Primary App Server (PAS) • Additional App Servers (AAS) Solaris 11 Solaris 11 AAS AAS SPOOL SPOOL PAS PAS ERS SCS DB Domain DB Domain Solaris 11 Solaris 11 Oracle 11g Oracle 11g

  21. Disaster Recovery Configuration SuperCluster 2 SuperCluster 1 • Site A - Production • Site B – DR/QA/DEV • Node 2 • Node 1 • Node 1 • Node 2 • GP Domain • GP Domain • GP Domain • GP Domain Oracle Solaris Cluster Geographic Edition Solaris 10 Solaris 10 Solaris 10 Solaris 10 PROD STANDBY PROD QA ZFS Replication DEV • DB Domain • DB Domain • DB Domain QA DB + DR DB • DB Domain Solaris 11 Solaris 11 Oracle Data Guard Solaris 11 Solaris 11 PRD DB Oracle RAC 11g R2 Oracle RAC 11g R2 Oracle RAC 11g R2 Oracle RAC 11g R2

  22. Results from Customer Testing

  23. Oracle Solution Center Hardware, Apps & Tech in Action • Customer Impact • Reduce Deployment Life-Cycle • Reduce Risk – Going Live • Strengthened Commitment to Customer Success • Capabilities • Performance Testing and Proof of Concept • Architecture & Design of Total Customer Landscape • Applications in Cloud

  24. Oracle Solution Center Global Presence • United States/Canada • Santa Clara, CA* • Broomfield, CO • Reston, VA • Atlanta, GA • Latin and South America • Mexico City, Mexico • Sao Paulo, Brazil • Asia Pacific • Beijing, China • Sydney, Australia • Tokyo, Japan • Europe, Middle East and Africa • Edinburgh, UK • Walldorf, Germany • Reading, UK • Elion, Estonia** • Inserve, Sweden** • ArrowECS, Finland** • Avnet, UK** • UAE, Tech Access** • WorkGroup IT, SA** • KSA, Tech Access** *Global Oracle Solution Center **Authorized Partner Oracle Solution Centers

  25. Large Manufacturing and Retail Company COMPANY OVERVIEW • Premier global retailer using SAP with Oracle Database SPARC SUPERCLUSTER BENEFITS • Consolidate and centrally manage SAP application environment on a single system • Leverage virtualization to customize domain configurations to specific application workloads • Rapid deployment and configuration of application infrastructure SOLUTION • Oracle SPARC SuperCluster • SAP applications running in Oracle Solaris 10 domains • High Availability of SAP Central Services through Oracle Solaris Cluster • High performance database through Exadata Storage Servers and Oracle Database • Legacy environment – Sun SPARC Enterprise M9000, EMC2 DMX SAN storage PERFORMANCE RESULTS • Data warehouse • 4x faster orders loading time • 2x-7x faster query times(Microstrategy front end) • Batch workload - SAP Controlling Profitability Analysis • 2x faster to prepare initial data • 2x faster to populate tables • OLTP • 30% faster response times Data WarehouseQueries SPARC M9000 and EMC SPARC SuperCluster SAP CO.PA Batch Times SAP Orders Loading Completion Times as % of Original

  26. Large U.S Government Agency Performance Evaluation – Rapid Setup and Migration • Existing Environment • 1.2 TB database • SAP App Tier, Central Services • Solaris 10 Zones • SPARC M5000 Complete SAP setup and migration • 1 week/16 man-days • 8 man-days – App tier with HA • 2 man-days – move app tier • 6 man-days – Oracle Solaris Cluster setup for SAP • 8 man-days – Database with HA • Oracle Database setup, Oracle RAC setup and data migration • O2O migration 25% DB reduction mainly due to DB reorganization

  27. Large U.S Government Agency (continued) Performance Evaluation – Test Results Completion Time Update System Statistics Results (seconds) • Queries: 4x to 285x Faster (Query table CDHDR) • Heavy I/O Load Test: 4x Faster • Update System Statistics Script • Generates stats on system and database • Reads all 73,000 database tables • Creates stats figures to be used by optimizer

  28. Large Oil and Natural Gas Explorer Performance Proof of Concept Project Customer goals • Increase system capabilities to enable • Consolidation of ERP systems • Increased analysis workload • Additional goals - reducing costs to operate and modernize systems Evaluated performance and best practices in three areas • Performance of customer specific tests • Comparison of backup performance with methods and options • Loading the system - faster method

  29. Large Oil and Natural Gas Explorer POC Configuration 10+ TB total customer data 9.6 TB DB 10 GbE Data Center Network • Used 2 T4-4 Servers configuration D: • Solaris 11 DB domain • - 2 T4 processors and 512GB • Solaris 10 App domain • - 2 T4 processors and 512GB • SAP ECC System: • 2 Application Servers: APP1, APP2 • - Solaris Zones in Solaris 10 App domain • Central Instance: CI • - Solaris Zone, Solaris 10 App domain • 2 RAC Instances : • - Solaris 11 DB domains • 6 Storage Cells • – 2 ASM Disk Groups: DATA and RECO SPARC SuperCluster Node 1 Node 2 X4500 App Domain App Domain Oracle Solaris 10 Oracle Solaris 10 APP2 APP1 CI DB Domain DB Domain Oracle Solaris 11 Oracle Solaris 11 InfiniBand Network 6 Oracle Exadata Storage Servers 7420

  30. Large Oil and Natural Gas Explorer Performance POC Steps • Copy DB files and SAP system image from Customer Storage to x4500 • Transit X4500 from customer to OSC • Copy x4500 data to internal ZFSSA • Start Oracle DB in new home from Solaris 10 domain • Upgrade Oracle DB 11.2.0.2 -> 11.2.0.3 • Migrate DB to ASM and RAC (*) • Create DB Services for Each App Server (*) • Adjust SAP App Servers to DB services (*) • Backup, Run Test, Restore, … - * Tested on Oracle Optimized Solution for SAP

  31. Large Oil and Natural Gas Explorer Performance Test Results • 2.6x performance improvements over best in house results • Custom test used for performance testing • In house testing included mix of SPARC and x64 • Tests were run both with and without Oracle RAC enabled • Oracle RAC configuration showed a 19% performance advantage

  32. Large Oil and Natural Gas Explorer Best NFS Performance Achieved Inside SuperCluster Optimized Solution tunings for NFS over InfiniBand delivered strong performance gains

  33. Large Oil and Natural Gas Explorer 12 TB/hr. Backup for SAP Database on SuperCluster RMAN Compression, with high performance backup target reduced disk-to-disk backup window

  34. Summary • Complete, Tested, Proven Solution for SAP • Built in High Availability • Accelerates all workloads – interactive, batch, reporting, loads, etc.

  35. Learn More oracle.com/sap and oracle.com/superclusteroracle.com/goto/optimizedsolutionsapQuestions?

  36. Graphic Section Divider

More Related