cisco’s intelligent automation for sap on · pdf fileauto/semi automation of index...
TRANSCRIPT
![Page 1: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/1.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Cisco’s Intelligent Automation for SAP on UCS Nathaniel Crook Systems Engineering Manager IASBU
![Page 2: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/2.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 2
Adapters on the Intelligent Automation Platform
Engine
Incident
Analysis & Task
Automation for SAP
TEO Automation Packs
VMWare Remedy
• Role-based access
• Task Delegation
• Process Execution
• Scheduling
• Event triggering
• Human Approvals
• Assignments & Notifications
• Auditing & Reporting
Tidal Enterprise Orchestration Platform
Corrective Actions for SAP
BW & BWA Automation
for SAP
System Refresh &
System Copy for SAP
Set of Core Processes, Activities, Events & Tasks
Automation Core Platform
Delivery
• Web Based Portal
• Client Console
• Reporting
• Ticketing Integration
• Operations Managers
• CLI
SSH UCS Networks DB
Network Support Automation
Compute/Cloud/UCS
![Page 3: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/3.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
SAP Incident Analysis Workflow Example
![Page 4: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/4.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Dialog Response Time
![Page 5: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/5.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Dialog Response Time
CCMS/SolMan: Where the Alert Begins
SAP Best Practice Parameters
Filter Through The Noise
![Page 6: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/6.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
SM 66 STAD
Page In/Out LAN.*
Locks, Full Table Scans, Disc I/O
Multiple Servers or Isolated?
Automate Incident Triage and Analysis
SM 50
![Page 7: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/7.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Automation
Summary
Automation
Summary
Automation
Summary
Automation
Summary
Automation
Summary Automation
Summary
Dialog Response Time
![Page 8: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/8.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Web Based Console for Alerts
![Page 9: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/9.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 9
Automation Summary Report
![Page 10: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/10.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
![Page 11: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/11.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
![Page 12: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/12.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
![Page 13: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/13.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
![Page 14: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/14.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
SAP Task Automation Workflow Example
![Page 15: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/15.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Automate Daily Health Checks
![Page 16: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/16.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Schedule the health
check to run multiple
times per day
Observe the
process as it
completes
Automation Summary for Data Collected
![Page 17: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/17.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 17
Other Out-Of-The-Box Automated Checklists BI Checklist Enterprise Portal Checklist
![Page 18: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/18.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
System Copy and System Refresh
![Page 19: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/19.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
A shorter overall copy window will allow for
more frequent copies
Elimination of manual errors
No missed steps such as turning off output
devices and RFC’s that can cause erroneous
data to be sent from QA to production
Multiple refreshes can run at the same time
without the need for a larger staff i.e. prod to
QA and prod to training
Web based alerts and email notification
19
Automated System Refresh and Copy
![Page 20: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/20.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 20 20
Templates Based on SAP Best Practices
![Page 21: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/21.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 21 21
Focus Strategy
A. Automation of the SAP Pre-Refresh Procedures Approvals and Notifications
Execute SM37 on the Source System
Execute SPAD & STRUST on the Target System
B. Orchestrate the SAP Data Migration R3 Load
Rman
Backup/Restore
C. Automation of the SAP Post-Refresh Procedures Final Sign Off and Review
Execute SM59, BDLS Optimization, SMLG on the Target System
D. Incorporate Custom Refresh Procedures
![Page 22: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/22.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Return on Investment
•QC3 Before TEO:
• QC3 weekly system copy used to take 2 hours every weekend for up to 50 individual steps
•QC3 After TEO:
• QC3 refresh runs fully automated in 15 min
• Improvement for approximately 50 refreshes per year
• Downtime reduced from 100 hrs to 12.5 hrs
•QC2 Before TEO:
• QC2 weekly system copy used to take 1 week
•QC2 After TEO:
• QC3 refresh runs fully automated in 1 weekend
• Downtime reduced from 168 hrs to 48 hrs
![Page 23: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/23.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Value Added Improvement - BDLS
Auto/semi automation of index creation
Query SAP System and determine top tables that require index on non-key field LOGSYS/AWSYS
For example, an index can optimize the validation step running in 5-10 min vs. a 4 hour search against a large table.
DB Adapter functions
Turn off all table logging and journaling
Use Optimized BDLS program
Cap search at a max 10,000 record read during verification process, enough to establish existance
Enhanced template uses cursor based update techniques
Use parallelized BDLS processing (Break out large tables in their own jobs)
DB Adapter functions
Remove temporary indexes
Restart table logging operations
Logical System Name Conversion of
approx. 1,500 DB tables
Tidal BDLS Program
Optimized Code
Template
Generated BDLS Program
For Client
Process Time: Parallelized
(multiple threads
Available)
Query / Validation
DB Update
![Page 24: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/24.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
SAP on UCS
![Page 25: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/25.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 25 25
Challenge: Reduce Data Center Operational TCO (Total Cost of Ownership)
Platform Value Differentiator in the Marketplace
Cisco UCS with Intelligent Automation
Cisco UCS
Reduces
Infrastructure
Operational TCO
Comprehensive Operational TCO Reduction across
the Enterprise
Cisco
Intelligent
Automation
Reduces
Application
Operational TCO
• Tidal Enterprise Orchestrator
• Tidal Intelligent Automation for SAP
![Page 26: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/26.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 26
Tidal Enterprise Orchestration Platform
![Page 27: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/27.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Nathaniel Crook
Value Proposition TEO for UCS
![Page 28: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/28.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 28 28
TEO for UCS Scenario Examples
1) TEO for UCS System Awareness
2) TEO for UCS - Application Awareness (SAP)
![Page 29: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/29.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 29
Tidal Enterprise Orchestration Platform
![Page 30: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/30.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
1) Data Center Hot Spot Scenario
• Temperature threshold breached
• Power threshold breached
Monitor UCS Server
Power Utilization
Monitor UCS Server
Temperature
Within Range? If No
Create Alert
Migrate Service Profiles
to Available Blades
TEO for UCS (System Awareness)
Provision VMs or OS
with TSP/BMC
Create Approval
Request
Reference “Available
UCS Blades”
![Page 31: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/31.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
TEO for UCS (System Awareness)
UCS Event trigger, could also be based upon a UCS Fault like a failed NIC
VMWare adapter takes action on the ESX host
Move the Service Profile to an available blade
VMWare adapter takes action on the ESX host
Web Based Approval Request Auto Generated
Shut Down UCS Server through UCSM
Boot the UCS Server through UCSM
![Page 32: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/32.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 32 32
What is it?
• Automate taking actions or tasks based on events and metrics in UCS and applications. For instance, dynamically repurposing hardware or moving hosted applications based on intelligent analysis.
Why does it matter?
• Creates an “intelligent automated system” that quickly reacts to UCS and application level events and metrics and can perform administrative or corrective actions. For instance, allocate appropriate resources on the fly based on events or analyzed conditions.
TEO for UCS (System Awareness)
![Page 33: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/33.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
Nathaniel Crook
Value Proposition Application Awareness SAP on UCS
![Page 34: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/34.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 34
![Page 35: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/35.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
SM 66 STAD
Page In/Out LAN.*
Locks, Full Table Scans, Disc I/O
Multiple Servers or Isolated?
Automate Incident Triage and Analysis
SM 50
![Page 36: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/36.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 36
Example: Application Awareness (SAP) Work Process Utilization
SAP Dialog Work
Process Utilization
Work Process
Analysis
Threshold Breached?
Create Alert
Locate “Available
UCS Blades”
Create Approval
Request
Bring Up New UCS
Blade with Service
Profile for SAP PROD
App Server
Repurpose Existing
DEV/QA SAP Blade
with Service Profile
for SAP PROD
App Server
Start and Configure
SAP App Server
SAPGUI & SMLG
![Page 37: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/37.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
TEO for UCS (Application Awareness for SAP)
![Page 38: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/38.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
TEO for UCS (Application Awareness for SAP)
![Page 39: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/39.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID
TEO for UCS (Application Awareness for SAP)
![Page 40: Cisco’s Intelligent Automation for SAP on · PDF fileAuto/semi automation of index creation Query SAP System and determine top tables that require ... Infrastructure](https://reader034.vdocuments.us/reader034/viewer/2022052607/5a6fdb0e7f8b9aa2538b74cd/html5/thumbnails/40.jpg)
© 2009 Cisco Systems, Inc. All rights reserved. Presentation_ID 40 40