How to start SAP HANA Administration Tool

hana administration and monitoring and hana administration architecture and sap hana administration activities and sap hana administration and security
Prof.WilliamsHibbs Profile Pic
Prof.WilliamsHibbs,United States,Teacher
Published Date:28-07-2017
Your Website URL(Optional)
Comment
HANA Administration: A Guide for Basis Administrators Bob Simard: Director SAP Basis – Method360, Inc. About This Presentation  “HANA The Appliance”  Appliances Don’t Need Administration Right? - Incorrect  My Goal is to Show what needs to be done  Not HOW to do it (although “it’s in there” in many cases)  This is NOT a TechEd Session  Minimal Technical Jargon  Not designed to be a “How-To’ for Basis Staff  I Will Cover the “Why’s” and “What’s” of HANA  From My Perspective – Technical Infrastructure  That Said – I Do consider Myself a “HANA Evangelist”  NOT a SAP Salesperson 2 Real Experience. Real Advantage. Agenda HANA: Why Now? HANA: What is it? HANA: Basis Administration BW on HANA: How Do You Get There? 3 Real Experience. Real Advantage. What We’ll Cover  HANA: Why Now?  Significant SAP ‘Technical Paradigm Shifts’  NetWeaver – Technology Issues: Impact on I.T. Agility  HANA: What is it?  It is Not the Same Old NetWeaver  BUT Many of its Technologies are Mature  Hana Admin Responsibilities: Vendor - Basis  Hardware Vender  Client’s Staff: “But it’s an appliance”  Basis Team – Activities / Responsibilities  HANA Example” BW on HANA 4 Real Experience. Real Advantage. Agenda HANA: Why Now? HANA: What is it? HANA: Basis Administration BW on HANA: How Do You Get There? 5 Real Experience. Real Advantage. HANA: Why Now? - Major Paradigm Shift Mid 90s: Client – Server Computing R2  Mainframe to Unix-based, distributed processing  Data ‘Optimized’ for disk retrieval DB Optimizer - Indexes Early 2000s: NetWeaver SAP BASIS  ‘Targeted Processing’  Same Base Code – NetWeaver Foundation 2011: HANA  In-Memory Processing  Analytical Appliance  Database 6 Real Experience. Real Advantage. SAP R/3 SAP BW SAP CRM SAP SRM HANA: Why Now? NW Problems I.T. Issues Client-Server Computing Lead to  Application Sprawl  ERP, BW, CRM, SRM, PI, GTS, LMNOP  Server Sprawl  From dozens to 100s Leading to  Ever-Increasing TCO  Higher Staffing  More Data Center Space  Loss of Agility  Over-all Dissatisfaction with I.T. 7 Real Experience. Real Advantage. HANA: Why Now? OLTP Has Reached Its Limits Performance Bottleneck: Memory and Disk Core(s)  More Memory: 64 – 512GBs lead to  ‘Partitioned’ Systems – VMware, LPar Cpu cache  Data ‘Optimized’ for disk retrieval DB Optimizer - Indexes Host Bus Adapters - Caching Physical Storage Optimization - RAID Main Memory  OLTP design NOT optimized for Main Performance Memory access Bottleneck  Even when loaded in RAM, we see a 40 - 60% stall rate between CPU Cache and memory Disk  This due to OLTP’s inherent design  e.g. Leaf Page Scan – Index Pages 8 Real Experience. Real Advantage. HANA: Reinventing Mass Data Processing “Roads? We Don’t Need no Stinking Roads” Taking the Best of Existing technology and Adding to it  In Memory Programming  Designed for rapid access  In Memory Database  Supercharged Data Warehouse  Column store, compression, no more aggregation  Instant Data Harmonization  ETL: SAP Landscape Transformation  Immediate Data Accessibility 9 Real Experience. Real Advantage. HANA: Why Now? HANA Leverages New Technology Performance Bottleneck: CPU Cache Core(s)  Inexpensive Memory – 2 TB Systems Cpu cache  VERY Fast ‘Bottleneck’ HANA Performance  Optimized Analytical Programming Bottleneck  Designed to work in concert with in memory data Main Memory  In-Memory Database  Data Structured to reside in memory  Both Row and Column-based Access  Utilizing Data Warehouse Constructs Disk e.g. Aggregation built into the technology 10 Real Experience. Real Advantage. HANA: Why Now? Business Requires SPEED Business Requires Agile I.T. Solutions  IT as a Cost Center Must Provide  Lower TOC  Higher ROI  Must have Rapid Role Out of Solutions  Robust, Inexpensive (RELATIVE) Hardware  Able to Process Large Volumes of Data  Real-Time  Immediate Answers to “What If” Questions  “Google-type” Predictive Answers  IT Can No Longer Act As A Barrier 11 Real Experience. Real Advantage. HANA: Why Now? Value Proposition Is It REALLY That Different?  Real-time Decision Making  Current Data from ERP / BW reflected Immediately in Reports  Lower I.T. TOC  “Appliance Model” – Decision is Small, Medium, Large  Versus Which Gear goes with what  Eliminate Database Licensing fees, administrative costs  Lower Landscape Costs  Uniform Administrative processes  Fewer vendors to manage  Accelerate Business Performance  Planning, Forecasting, Pricing, etc based on immediacy of data from unlimited sources  Eliminate “I.T. Shadow”: Empower Business Self-service analytics 12 Real Experience. Real Advantage. HANA: Why Now? Section Take-Aways SAP Processing Paradigm Shift  Designed to Leverage Today’s low-cost Technology  Must have Rapid Role Out of Solutions  “Appliance” Gear  Able to Process Large Volumes of Data  Real-Time  Immediate Answers to Immediate “What If” Questions  The “Gear” is the “Gear”  Certified - Uniform  Robust, Inexpensive (RELATIVE) Hardware 13 Real Experience. Real Advantage. Agenda HANA: Why Now? HANA: What is it? HANA: Basis Administration BW on HANA: How Do You Get There? 14 Real Experience. Real Advantage. HANA: What is it? Software as a Service  Simple Component View:  HANA Studio  Development  Administration  HANA End User Clients  Data Presentation  Data Providers  Data Harmonization - Data EXPLOSION  HANA Appliance  Database  Software 15 Real Experience. Real Advantage. HANA: What is it? Both an Appliance and Hardware  Technical View (Real):  HANA and its Components  Several Things to note  Solution Manager  SMD Agent  HANA App Data Collection  Central Management More on this in a minute  Software Update Manager (SUM)  Provides OSS Access  Multiple HANA Systems  HANA Scales Out  HA: Provides Redundancy Optional 16 Real Experience. Real Advantage. HANA: What is it? Usage - Three Major Steps  Load: From Existing Source(s)  SAP Landscape Transformation (SLT)  BOBJ Data Services  BOTH require Separate Server  Model: SAP HANA Studio  Information Developer’s Console  Analyze: SAP Tools – BW (BEx, BOBJ, Excel) 17 Real Experience. Real Advantage. HANA: What is it? Three Major Steps: Load Data  Loading Data: Technical Components  SAP Landscape Transformation (SLT)  BOBJ Data Services SLT Server Data Sources HANA Appliance • NW 7.02 • Add-on • HANA Database ERP System • DMIS • Load Controller 2010_1_700 • SAP ERP • Host Agent (7.20) • Host Agent (7.20) SMD • Sybase Replication Server 15.5 • Sybase Replication Agent Agent Real-time Replication Non-SAP Data SMD Agent Data Services 4.0 SMD Integrated ETL Transfer Monitor • DSS Job Server Agent • DSS Repository 18 Real Experience. Real Advantage. HANA: What is it? Three Major Steps: Modeling  Model: SAP HANA Studio  Information Modeler  Column Based Access – FAST 19 Real Experience. Real Advantage. HANA: What is it? Three Major Steps: Analyze  Analyze: SAP Tools  Native Support of Universes from  WEBI  Xcelsius (Dashboards) 20 Real Experience. Real Advantage.

Advise: Why You Wasting Money in Costly SEO Tools, Use World's Best Free SEO Tool Ubersuggest.