1 / 60

Architecting Availability & Performance for SAP Environments

Learn about high availability and performance considerations for SAP environments, including cluster solutions and database tuning.

michaelbwilliams
Download Presentation

Architecting Availability & Performance for SAP Environments

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. Architecting Availability & Performance for SAP Environments Todd TolesSolutions Architect, VERITAS Raymond SuarezProduct Manager, VERITAS

  2. Agenda • SAP High Availability Fundamentals • SAP High Availability with VERITAS Cluster Server™ • SAP Performance Fundamentals • Performance Questions Needing Answers • Product Demo • Services Levels • Database Tuning

  3. Architecting Availability for SAP Environments

  4. The SAP Database • The SAP database is where all data is stored. • It can reside in the same service group as the CI, be in another SG, or be outside of the cluster • This database is usually a Single Point of Failure (SPOF) except if Oracle 9i RAC or a similar solution is used.

  5. Central Instance • This SAP instance (the Central Instance) is the key component of the SAP environment • The database MUST be up before the CI starts. • The Central Instance is a SPOF • It generally serves out configuration information and sometimes SAP binaries (via CIFS or NFS)

  6. Application (Dialog) Instances • Must be started after the DB and CI instances are online • Mount data (via CIFS or NFS) from the CI • Talk to the client, the database, and the CI • Generally are not SPOFs.

  7. So What Can We Cluster? • Database • DB/2, Oracle, Informix, MS SQL Server • Central Instance • Basis Kernel 4.6, 4.7 Enterprise, and 6.2 • On Solaris, HP-UX, AIX, and Win2K • Dialog (Application) Instance • Same as CI

  8. So What About Parallel Database Solutions? • Oracle 9i RAC • Supported with Database Edition for Oracle/Advanced Clustering • DB/2 EEE SMP • Supported by the VCS agents for DB/2 on AIX, Linux, and Solaris

  9. SAP Cluster System1 System2 System3 System4 System5 DB/2 (R/3) R/3 4.7 App BI 3.0B CI Oracle(BI) R/3 4.7 CI Service Group VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Shared Disk Array VERITAS HA Solution for SAP Let’s look at a real application…

  10. SAP Cluster System1 System2 System3 System4 System5 R/3 4.7 App BI 3.0B CI DB/2 (R/3) R/3 4.7 CI Oracle(BI) Service Group VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Shared Disk Array VERITAS HA Solution for SAP System 4 Goes Down…

  11. SAP Cluster System1 System2 System3 System4 System5 R/3 4.7 App BI 3.0B CI DB/2 (R/3) Oracle(BI) Service Group R/3 4.7 CI VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Shared Disk Array VERITAS HA Solution for SAP R/3 4.7 Central Instance moved to System 5

  12. SAP Cluster System1 System2 System3 System4 System5 R/3 4.7 App BI 3.0B CI DB/2 (R/3) Oracle(BI) Service Group R/3 4.7 CI VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Shared Disk Array VERITAS HA Solution for SAP System 5 fails…

  13. SAP Cluster System1 System2 System3 System4 System5 R/3 4.7 App BI 3.0B CI DB/2 (R/3) Oracle(BI) R/3 4.7 CI Service Group VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Shared Disk Array VERITAS HA Solution for SAP R/3 4.7 Central Instance moves to System 3

  14. SAP Cluster System1 System2 System3 System4 System5 Oracle(BI) BI 3.0B CI DB/2 (R/3) R/3 4.7 CI Service Group VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Shared Disk Array VERITAS HA Solution for SAP Oracle instance moves to System 1 and bumps 4.7 App Server

  15. VCS HA Daemon VCS HA Daemon HA Daemon Talks Via High Speed Heartbeat Interconnect (GAB/LLT) VProSAP Agent VProSAP Agent Start Start Stop Stop Clean Clean Monitor Monitor VERITAS HA Solution for SAP How does VCS keep track of what is running?

  16. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System3 R/3 4.7 CI R/3 4.7 CI System4 System2 BI 3.0B CI BI 3.0B CI R/3 4.7 DB R/3 4.7 DB BI 3.0B DB BI 3.0B DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Primary Secondary Shared Disk Shared Disk Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP Now consider a global fail-over…

  17. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System3 R/3 4.7 CI R/3 4.7 CI System4 System2 BI 3.0B CI BI 3.0B CI R/3 4.7 DB R/3 4.7 DB BI 3.0B DB BI 3.0B DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Primary Secondary Shared Disk Shared Disk Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP Primary data center has catastrophic failure…

  18. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System3 R/3 4.7 CI R/3 4.7 CI System4 System2 BI 3.0B CI BI 3.0B CI R/3 4.7 DB R/3 4.7 DB BI 3.0B DB BI 3.0B DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Primary Secondary Shared Disk Shared Disk x Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP Stop Data Replication

  19. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System3 System4 R/3 4.7 CI R/3 4.7 CI BI 3.0B CI System2 BI 3.0B CI R/3 4.7 DB R/3 4.7 DB BI 3.0B DB BI 3.0B DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Secondary Primary Shared Disk Shared Disk x Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP Promote Secondary Disk…

  20. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System2 System3 System4 R/3 4.7 CI BI 3.0B CI R/3 4.7 CI BI 3.0B CI R/3 4.7 DB BI 3.0B DB BI 3.0B DB R/3 4.7 DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Secondary Primary Shared Disk Shared Disk x Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP Start Databases in parallel…

  21. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System2 System3 System4 R/3 4.7 CI BI 3.0B CI R/3 4.7 CI BI 3.0B CI R/3 4.7 DB BI 3.0B DB BI 3.0B DB R/3 4.7 DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Secondary Primary Shared Disk Shared Disk x Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP Start the remaining instances in parallel

  22. Site A: Cluster 1 Site B: Cluster 2 WAN Global Cluster (GCM) System1 System2 System3 System4 R/3 4.7 CI R/3 4.7 CI BI 3.0B CI BI 3.0B CI R/3 4.7 DB BI 3.0B DB BI 3.0B DB R/3 4.7 DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Secondary Primary Shared Disk Shared Disk Replication (VVR) 4.7 CI BI CI BI DB 4.7 CI BI CI BI DB 4.7 DB 4.7 DB 4.7 DB 4.7 DB VERITAS HA Solution for SAP When appropriate, reverse replication…

  23. Dallas: Cluster 1 Charlotte: Cluster 2 WAN Global Cluster (GCM) System1 System2 System3 System4 R/3 4.7 CI BI 3.0B CI R/3 4.7 CI BI 3.0B CI R/3 4.7 DB R/3 4.7 DB BI 3.0B DB BI 3.0B DB VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM Production Environment Development Environment Primary Secondary Shared Disk Shared Disk Replication (VVR) Development Primary Disk Production Primary Disk Production Replicated Disk VERITAS HA Solution for SAP Much easier to re-purpose hardware

  24. ERP BI System1 System2 REPLICATED Service Group REPLICATED Service Group REPLICATED Service Group REPLICATED Service Group REPLICATED Service Group REPLICATED Service Group VxVM VxFS DBE VCS VVR GCM VxVM VxFS DBE VCS VVR GCM SCM Disaster Recovery Site Financials Disk Replication Disk Replication Replicated Disk VERITAS HA Solution for SAP Much easier to multi-purpose offsite hardware

  25. VERITAS Data Protection for SAP R/3 Key Features • Centralized Administration/Hot Backup • Reduces cost of supporting large environments • Reduces backup windows • Flexibility • Full integration with BACKINT • Backups run through NetBackup or SAP GUI • Scheduled and automatic backups • Disaster Recovery • Simplified • More than one copy of the data • Supports Vaulting

  26. SAP R/3 Applications • SAP Tools • brbackup • brrestore • brarchive • brinquire • brconnect Oracle Database SAP Tools (SAPDBA) BACKINT NetBackup for SAP R/3 VERITAS NetBackup Tape Media VERITAS Data Protection for SAP R/3 Architecture

  27. VERITAS NetBackup™ for SAP R/3 Key Features • Heterogeneous UNIX/Windows solution • Provides equal functionality and performance on all platforms • SAP Certification • NetBackup versions 4.5 and 3.4.x • SAP BAPI Certification • NBU for SAP R/3 supports the complete BACKINT BR command set

  28. But what about DB/2 and SQL Server? • DB/2 and Microsoft SQL Server are supported with SAP using the standard database agents for NBU.

  29. NetBackup for SAP R/3: Backup Strategies • 1. Cold vs. Hot (or mixed?) • Does the SAP R/3 database need to be available at all times? • Is there a backup window available to do a complete cold backup? • Is there a backup window available to do a complete hot backup? • What is an acceptable amount of downtime to do a recovery? • Example of a mixed backup strategy: • Cold SAP R/3 database backup once a month • Hot SAP R/3 database backup once a week • Incremental hot backups done nightly

  30. NetBackup for SAP R/3: Backup Strategies • 2. Test your backup and recovery strategy • 3. Incorporate a vaulting strategy with your NetBackup for SAP R/3 data protection strategy • NetBackup Vault • 4. Plan responses to failure • Media failures • Non-Media failures • User errors • SAP R/3 database failure

  31. Factors To Consider: • Consider When Planning Your SAP R/3 Backup and Recovery Strategies: • Recovery Time • Backup Windows • Performance Requirements • Availability Requirements • Disaster Recovery Strategy • Acceptable data loss • Risk of user error • SAP R/3 Database size • Growth plans/Knowledge and turnover of administrators

  32. Managing SAP Performance

  33. Sisyphus & Performance Mgmt. The Role of the Basis Team

  34. Managing Application Performance • How do you view the whole end-to-end user experience? • How do you Diagnose problems after they have occurred? • Can you differentiate network problems from application problems? • Can you monitor slowdowns in front-end systems like ITS Web? • Difficulty understanding location-specific response & availability issues? • Difficulty measuring the impact of ABAP code change?

  35. Traditional 89% Windows Client ABAPServer Database Server ITS Configuration 10% Browser Client Web Server New Technology 1% Java Client Java/ABAPServer SAP Environment – Not just the pieces • Problem areas: • Database • Application Server • Web Server • Network Database Server

  36. Identify usage profile of Oracle database

  37. Associate SAP activities and Oracle activities

  38. Identify main SQL consumers

  39. Understand SQL inefficiencies

  40. Understand SQL inefficiencies

  41. Understand SQL inefficiencies

  42. Explore solutions in packaged application

  43. Evaluate, implement and verify a solution

  44. In Summary • Establish end-user service levels • Ability to see the end-user experience • Ability to provide in context component analysis • On going reporting for team and management • Using alerts as a watchdog

  45. Agile Applications 100% Assurance A VERITAS i3 Case Study: EDS Applications Hosting Services David Fuqua Innovation Director, EDS Hosting Services

  46. EDS Application Hosting Services • Usage based pricing. Only pay for what you use. • Flexible FTE Model • Scalable Infrastructure • Enhance business growth • Build competitive advantage – without adding to your total cost of ownership • 100% application availability assurance backed by service credits • Comprehensive services unparalleled in the industry • Provides for the day-to-day operations of mission critical software • Hardware sizing and provisioning • Helpdesk support • Operational support • Technical application administration

  47. SLA SLA SLA SLA SLA SLA Business Applications OperatingSystem Servers Hardware Appliances Storage Compartment Networking Gear 100% Assurance: Industry-best SLA Service Backed by Strict Financial Penalties Every Component Every Event Internet EDS Shared Customer Networking Equipment Networking Equipment Web Server Complete Management Web Server Complete Management SLA • 100% uptime - assurance that every minute of downtime counts • Aggressive problem resolution driven by individual time to repair • 15 minutes for redundant systems • Replace faulty hardware • Troubleshoot and restore application • Troubleshoot and restore connectivity to Customer Networking Equipment • Escalating Service Credits • SLA compliance visibility for every incident • “...we find EDS’ SLA guarantees to be industry-leading amongst the companies’ peers...Customers looking for hosting service providers this year should have EDS on their short-list, as the company expands its overall corporate commitment to service quality with new offerings such as this one.”Giga Information Group

  48. Strategic Benefit – Improve EDS Hosting Better Cost Management Improve Quality • Time spent on routine tasks optimized with automation • Expertise is captured and easier to leverage • Consistency simplifies management & troubleshooting • Best practices are leveraged Increase Responsiveness • New deployments require a fraction of the time • Automation & built-in expertise simplify deployment

  49. 24 x 7 Operations Center • How do we do it? • Engineers up front – Skill at the front line! • Fix-it first • Time to Repair Guarantees backed with Service Credits (100% SLA) • What are the results? • Problem recognition: • 1 minute alert response • Problem resolution: • 80% problem containment Enables the 15 minute Time to Repair SLA

More Related