Exadata x4 for_sap

75 %
25 %
Information about Exadata x4 for_sap
Technology

Published on January 30, 2014

Author: franmod

Source: slideshare.net

Description

Workshop Exadata for SAP

WorkShop Exadata for SAP Last updated – Nov 27, 2013 1 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

A FULLY INTEGRATED SYSTEM Engineered Certified Deployed Supported Tested Packaged Upgraded Managed TOGETHER 2 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

GROUNDBREAKING TIME TO MARKET FEWER PIECES TO BUY, DEPLOY & MAINTAIN 100’s of Components 1000’s of Hours 3 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.   1 Machine 1 Day

Pre-built and Optimized Out-of-the-Box Time (Days) 4 Custom Configuration Performance Achievement Performance Achievement 100% Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Test & debug failure modes Assemble dozens of components Measure, di agnose, tun e and reconfigure Time (Months) Multivendor finger pointing

Exadata Database Machine  The ultimate platform for all database workloads – OLTP, Warehousing, Database as a Service  Most advanced hardware – Fully scale-out servers and intelligent storage with unified InfiniBand connectivity and PCI flash  Most advanced software – Database optimized compute, storage, and networking algorithms dramatically improve performance and cost  Standardized, optimized, hardened end-to-end 5 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Same Exadata Architecture Complete | Optimized | Standardized | Hardened Database Platform  Standard Database Servers – 8x 2-socket servers  192 cores, 2TB DRAM or – 2x 8-socket servers  160 cores, 4TB DRAM  Unified Ultra-Fast Network – 40 Gb InfiniBand internal connectivity  all ports active – 10 Gb or 1 Gb Ethernet data center connectivity  Scale-out Intelligent Storage Servers – 14x 2-socket servers  168 faster cores in storage – 168 SAS disk drives Fully Redundant 6 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.  672 TB HC or 200 TB HP – 56 Flash PCI cards  44 TB Flash + compression

Unique Software Optimizes Database Processing  Query offload in storage – Data intensive query operations offloaded to storage CPUs – 100 GB/sec SQL data throughput – Storage Index data skipping  Database storage compression – Hybrid Columnar for 10x DB size reduction and faster analytics  Database optimized PCI Flash – Smart caching of database data – 2.66 Million Database IOs/sec – Smart Flash log speeds transactions 7 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.  Database optimized QoS – End-to-end prioritization from application to DB and storage  Database optimized availability – Fastest recovery of failed database, server, storage or switch – Fastest backup. Incremental offload – Exachk top-to-bottom validation of hardware, software, settings  Database optimized messaging – SQL optimized InfiniBand protocol for high throughput low latency SQL

Innovation Continues: Recent Enhancements  Query offload in storage – Offload searches on LOBs (12c) – Offload joins for non-parallel queries (11.2.0.4)  Database optimized compression – Hybrid Columnar enhanced for OLTP – and for Spatial and Text data (12c)  Database optimized PCI Flash – Ultra high speed flash compression (X3 & X4) at multi-million IOs/sec – Automatic caching for table scans – Faster file initialization 8 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.  Database optimized QoS – Prioritization of CPU and IO by multitenant pluggable database (12c)  Database optimized availability – Prioritize recovery of critical DB files (11.2.0.4)  Database optimized messaging – End-to-End prioritization of critical database messages (11.2.0.4), including log writes and RAC

Exadata X4 is the Fifth Generation DB Machine DATA WAREHOUSING OLTP DATABASE CONSOLIDATION FLASH CENTRIC DATABASE AS A SERVICE 9 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

No Performance Bottlenecks for Consolidation  Best way to ensure performance is to avoid bottlenecks  Exadata has unique extreme performance for complex workloads that mix OLTP, DW, batch, reporting - Millions of I/Os per second, 100 GB/sec of throughput - Sub-millisecond response times - Highest bandwidth network  Unique software optimizations that eliminate bottlenecks - e.g. Storage Offload, Smart Flash logging 10 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

What are SAP customers pain points? pain points beyond Performance  Complexity  Database and Storage silos  Too many vendors  Trial and error  High manageability  Efficient High availability and Disaster Recovery  Backup/Restore time  High IT cost 11 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Traditional SAP Landscape Deployment Sprawl Develops Over Time SAP CRM DEV PRD QAS PRD SAP HR Partners DEV QAS Employees SAP PLM SAP SCM DEV DEV Vendors QAS Customers PRD PRD 12 QAS Copyright © 2013, Oracle and/or its affiliates. All rights reserved.  Many components  Poor utilization Storage Systems  Complex management

Oracle Optimized Solution Approach Sprawl Contained in Oracle PROD QA/DEV  Consolidated system Applications  Virtualized resources SAP PLM Production Environment SAP PLM QA Environment Development And Test Environment  Complete management SAP SCM QA Environment Training Systems SAP HR Production Environment Partners SAP CRM QA Environment SAP SCM Production Environment Employees SAP CRM Production Environment SAP HR QA Environment Sandbox Vendors Customers 13 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

14 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

15 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Why considering Exadata for SAP Safe transition to a New Era  Certified by SAP  Runs SAP unchanged  Eliminate systems integration trial-and-error  Better performance out-of-the-box  Reduce vendors to Oracle and SAP  Best support (identical hw in Walldorf)  Fast and Online migration  Apply existing personnel, skills, Oracle licenses  Less administration, simpler patching, greater uptime  Consolidate platforms and databases, reduce power and cooling 16 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Why is Exadata Storage so FAST for SAP? • Intelligent storage – Scale-out InfiniBand storage – Smart Scan query offload + + + • Smart PCI Flash Cache – Accelerates random I/O up to 30x – Triples data scan rate 17 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

How can I find out who can benefit from Exadata? • SAP NetWeaver 7.0 and higher • Review Oracle AWR Report • Review SAP EarlyWatch Alert: • Z*-programs (home grown reports) • (BW) queries and reports 18 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

AWR through DBA Cockpit 19 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

EarlyWatch Alert (Online Transactions) 77% DB time 93% DB time 20 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Exadata for SAP Extreme Performance  Massively parallel high volume hardware to quickly process vast amounts of data – Exadata runs data intensive processing directly in storage – I/O is no more the major wait event  Fits best if large/complex InfoCubes, queries, transactions, and large Ad-hoc Custom Reports are business issue.  The more “home grown” reports the more SAP customers can benefit from Smart Scan: – spend large time in the database – run I/O intensive operations 21 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Exadata for SAP Migration without disruption  Supports all SAP NetWeaver 7.x ABAP and Java products & industry solutions e.g.: ‒ SAP ERP 6.0 (or SAP ECC 6.0) ‒ SAP BW 7.x ‒ SAP CRM, SRM, SCM (2005 / 2007 / 7.x) ‒ SAP Oil&Gas 2005 / 6.x ‒ SAP Banking Services 5.0 / 6.0 / 7.0 / 8.0 ‒ Check www.service.sap.com/PAM for more Less Risk Better Results 22 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.  SAP: Unicode and non-Unicode  Operating System: Oracle Linux 5 or Solaris 11 ‒ Check SAP Note 1590515 for more details

Exadata for SAP Migration without disruption “cont”  SAP tools support Exadata migration  SAP High Availability is simple ─ Based on Oracle Clusterware and free of charge  SAP Application tier continues to run ─ On any platform according to SAP’s MAP (HP-UX, Solaris SPARC/x86, AIX, Windows, Linux: RedHat, Suse, and Oracle) ─ (existing) shared file system for SAP files and directories  SAP Application can run on Exalogic 23 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

SAP on Exadata: All Nodes Active with RAC Node 1 E X A D A T A Node 2 Oracle Instance 1 RAC1 Listener 1 Automatic Storage Management (ASM) Oracle Instance 2 RAC2 Listener 2 SAPCTL Central Services (ASCS/SCS) Central Services Replicated Enqueue (ASCS/SCS) ERS D01 DVEBMGS00 24 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. D02

SAP y Oracle http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0411371-9eea-2e10-43bf-f04e3213d6b0?QuickLink=index&overridelayout=true&58725087882526 25 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

26 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Oracle Support for Performance and Availability ORACLE PLATINUM SERVICES Complete. Integrated. Proactive.  24/7 support coverage  Specialized Engineered Systems Support Team High Availability Services. No Additional Cost.  Better support for the complete Oracle stack – Includes higher support levels for Database software  2-hour onsite response to hardware issues1  24/7 Oracle remote fault monitoring  New updates and upgrades for  Industry-leading response times: Database, Server, Storage, and OS software – 5 Minute Fault Notification – 15 Minute Restoration or Escalation to Development – 30 Minute Joint Debugging with Development  Patch deployment by Oracle engineers 1 Covered system must be within an Oracle two-hour service area to receive two-hour response as a standard service. Available now for certified configurations on Oracle SuperCluster Oracle engineers perform patching services up to four times per year 27 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Exadata for SAP Oracle’s Strategic Database Platform  Engineered System: one Integrated System with all the required hardware (servers, network, storage) and software (OS, Oracle Database and Options)  One Architecture for SAP NetWeaver Business Suite, SAP NetWeaver BW and Consolidation with non-SAP in a private Database Cloud  Solves the IT Challenges faced by organizations - Avoids and removes database and storage silos - Makes all workloads faster – not only SAP - Very smooth migration (online, no SAP changes etc.) 28 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Benefits to IT | Business Benefits Simplify IT Work Faster & Smarter 2-Day Deployment Real-Time BI Near RealTime Batch Deploy in Days Administer with Less Real-Time BI Near Real-Time Batch 1-800SUPPORT Standard Configurations Global Scale OLTP Deeper Analytics 1-800-SUPPORT 29 Less Administration Consolidate|Standardize Internet-Scale OLTP Deeper Analysis Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Información Adicional  MAA  Backup  DR + Backup 30 Copyright © 2013, Oracle and/or its affiliates. All rights reserved.

Oracle Maximum Availability Architecture Production Site Application Continuity – Application HA RAC – Scalability – Server HA Global Data Services – Service Failover / Load Balancing Flashback – Human error correction Edition-based Redefinition, Online Redefinition, Data Guard, GoldenGate – Minimal downtime maintenance, upgrades, migrations 31 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Active Replica Active Data Guard – Data Protection, DR – Query Offload GoldenGate – Active-active – Heterogeneous RMAN, Oracle Secure Backup – Backup to tape / cloud

Oracle Maximum Availability Architecture Production Site Active Replica Application Continuity – Application HA RAC – Scalability – Server HA Active Data Guard Global Data Services – Service Failover / Load Balancing Flashback GoldenGate – Human error correction Edition-based Redefinition, Online Redefinition, Data Guard, GoldenGate – Minimal downtime maintenance, upgrades, migrations 32 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. – Data Protection, DR – Query Offload – Active-active – Heterogeneous RMAN, Oracle Secure Backup Dev/Test – Backup to tape / cloud

Complete – Backup and Recovery Who Better to Backup Oracle Than Oracle? Storage Expansion Rack • Fastest Backup and Restore • ILM Historical Archive • Second DATA2 Disk Group Ethernet InfiniBand Network 10GigE or InfiniBand Network 10GigE or InfiniBand Network 33 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Oracle Secure Backup Admin Server Oracle Secure Backup Media Servers Fiber Channel SAN SL3000 tape library • Offsite Backups • Vaulting ZFS Storage Appliance • Backups of database & non-database files • Snapshots • Clones

Create a Plan Group Databases by RTO / RPO •RTO < 5 minutes, RPO = Near-zero data loss •Incrementally Updated Backup Strategy – 2 day recovery on disk •Fast recovery area on Exadata or Exadata Expansion Rack •Backup to tape from the standby – 7 year retention period •Backups encrypted on tape via tape drive encryption Active Data Guard Remote Standby FRA •RTO < 6 hours, RPO < 1 hour •Full / Incremental backup – 1 week retention on disk •Disk backup to ZFS Storage Appliance •Fast recovery area on Exadata •RMAN backup compression or ZFS compression •RTO > 6 hours, RPO < 1 day •Backup directly to tape – 3 month retention period •Remember Archived Log sweep Exadata Expansion Rack 34 Tape Backup ZFS Storage Appliance RMAN Disk Backup Offsite Location Note: Solutions may vary based on database size (e.g. 100 TB data warehouse) Copyright © 2013, Oracle and/or its affiliates. All rights reserved. StorageTek Tape Library

Exadata Database Machine Backup Backup Destinations Options Exadata Database Machine 21 TB/hour Exadata Storage Expansion Rack Fastest 27 TB/hour Up to 50 TB/hour for incremental 35 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. ZFS Storage Appliance Flexible 6 - 8TB/hour Snapshots & Clones Oracle Sun StorageTek Tape Library Economical 5 – 6TB/hour (Dependent on # of tape drives)

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Why Oracle Database and Engineered Systems for SAP?

3 Oracle Exadata Database Machine for SAP customers is a highly engineered and pre-validated configuration. It provides built in High Availability, ‘out ...
Read more

DBRUYI | Welcome...

DBRUYI Database and Data End-to-End ... Oracle RAC for SAP. ... Migrated databases from Exadata X3 to Exadata X4 and migrated single instances SAP CRM/ECC ...
Read more

Exam Name: Oracle Exadata X3 and X4 Administration DEMO

Exam Name: Oracle Exadata X3 and X4 Administration ... Reference: Best Practices for Implementing a Data Warehouse on the Oracle Exadata Database
Read more

Exadata Flash Cache Compression - Oracle Wiki - Oracle ...

... Toad for Oracle Toad for SQL Server Toad for SAP Solutions ... on an Exadata X4-2 which hosts a ... Exadata Flash Cache Compression is discontinued ...
Read more

Gather system stats on EXADATA X4-2 throws an ORA-20001 ...

Home » Platforms » Oracle » Oracle Blog » Gather system stats on EXADATA X4-2 throws an ORA-20001,ORA-06512
Read more

SAP on Oracle Engineered Systems | SCN

SAP on Oracle Engineered Systems. ... Release 1 running Oracle Linux 6 for SAP ... for the Oracle Database Appliance X4-2 with Oracle ...
Read more

Oracle Engineered Systems for SAP

Oracle Engineered Systems for SAP Oracle ... Complete clustering solution for SAP high-availability resources such as central ... (ODA X4-2 and prior ...
Read more