ITM110 How Does SAP Solution Manager Support SAP HANA?

ITM110How Does SAP Solution Manager SupportSAP HANA?SAP TechEd 2013

DisclaimerThis presentation outlines our general product direction and should not be relied on in making apurchase decision. This presentation is not subject to your license agreement or any other agreementwith SAP. SAP has no obligation to pursue any course of business outlined in this presentation or todevelop or release any functionality mentioned in this presentation. This presentation and SAP'sstrategy and possible future developments are subject to change and may be changed by SAP at anytime for any reason without notice. This document is provided without a warranty of any kind, eitherexpress or implied, including but not limited to, the implied warranties of merchantability, fitness for aparticular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in thisdocument, except if such damages were caused by SAP intentionally or grossly negligent. 2013 SAP AG or an SAP affiliate company. All rights reserved.2

Agenda1. Introduction: SAP Solution Manager and SAP HANA2. How to connect SAP HANA to SAP Solution Manager?3. Monitoring of SAP HANA via SAP Solution Manager4. Doing Root Cause Analysis of SAP HANA with SAP Solution Manager5. Extend your Change Control Management towards SAP HANA6. Even More Valuable Features of SAP Solution Manager 2013 SAP AG or an SAP affiliate company. All rights reserved.3

What is SAP Solution Manager?IntroductionIT Service ManagementIT Portfolio and Project lioEnhancementServiceRequestMinor ReleaseUrgent ChangeRequest ectMajor ReleaseDesign MgmtBusiness Process Monitoringand AnalyticsBuild MgmtBuildExecutionTest MgmtTestExecutionRelease &DeploymentMgmtDeploymentexecutionChangeMonitoring of Systems, TechnicalScenarios and End User ExperienceRun SAP like a FactoryBuild SAP like a FactorySAP Solution Manager supports SAP HANA (as of SAP Solution Manager 7.1 SP05) 2013 SAP AG or an SAP affiliate company. All rights reserved.4

SAP HANA as Part of the Customer SolutionSAPCRMSybaseUnwiredPlattformWarehouseSAP GUISAPHANASAP SRMSAP EPPortalHANAStudioSAPBusinessClientSAPSCMSAPERPBW onHANASAP Solution Manager supports your entire solution (including SAP HANA) 2013 SAP AG or an SAP affiliate company. All rights reserved.5

Supporting SAP HANA – Two Use CasesClientClientSAP Business ObjectsBusiness IntelligenceApplicationData ModelsXSSAP HANA Application logic managed by SAPHANA SAP Solution Manager receives datafrom HANA studio (and SAP BusinessObjects) 2013 SAP AG or an SAP affiliate company. All rights reserved.Side-By-Side ScenarioClientClientSAP NetWeaverApplication ServerSAP NetWeaverApplication ServerMDXHTTP(S)ClientIntegration ScenarioSQLNative HANA UsageSAP HANA Application logic managed by SAPNetWeaver AS SAP Solution Manager receivesdata from SAP NetWeaver AS andHANA StudioExistingDBSAP HANA Application logic managed by SAPNetWeaver AS SAP Solution Manager receives datafrom SAP NetWeaver AS and HANAStudio Replication with existing DB6

Connect SAP HANAto SAP Solution Manager

HANA and SAP Solution Manager Data Exchange FlowSAP HANA HostRoot CauseAnalysisTechnicalMonitoringFile SystemBrowserSystemMonitoring pull DiagnosticsAgentSAP Solution ManagerCPUMemorySAP Host ControlFilesystemLogsAvailabilityLMDBSAP HANA DatabaseSLDsldregDatabase StructureInformationpush 2013 SAP AG or an SAP affiliate company. All rights reserved.8

Technical System Setup in Solution ManagerGuided Procedure in ‘Configuration’Workcenter:Set up SAP Solution Manager Setup of DBACockpit Setup of Performance Warehouse Setup of Technical System MonitoringSetup of the Managed System: Assigning Diagnostics Agent to system System Parameters:– Database Related Configuration– Enterprise Manager Starting Extractors 2013 SAP AG or an SAP affiliate company. All rights reserved.9

SAP EarlyWatch Alert - OverviewSAPSolutionManagerMonitoredSystemSAP Support31If red ratingSend EWA DataCollect DataProcess EWA DataImplementCheck EWA Reportautomated forward toSAP*Check red rated EWAReportContact Customer andcreate Service Planrecommendations2ImplementDeliver ServicesContact Customerrecommendations(for example EarlyWatch)45Customer 2013 SAP AG or an SAP affiliate company. All rights reserved.SAP10

Setup of SAP EWA in SAP Solution ManagerRequired RFC Destinations: READ Destination (from Solution Manager tothe Managed System) RFC Destination from the Managed System toSolution Manager (to the Application Client) 2013 SAP AG or an SAP affiliate company. All rights reserved.11

Configuring Technical MonitoringConfiguration Workcenter Technical Monitoring Assign Monitoring template Adapt template to your requirements (scope, incidents, e-mail and SMS notifications, reporting ) 2013 SAP AG or an SAP affiliate company. All rights reserved.12

Monitor your SAP HANA withSAP Solution Manager

Introducing Monitoring and Alerting in SAP Solution ManagerSAP Solution ManagerMonitoring & AlertingInfrastructureManaged Systems pull data Diagnostics AgentMetric ViewerAlert TypeAlert Details 2013 SAP AG or an SAP affiliate company. All rights reserved.14

SAP Solution Manager – System MonitoringDatabase metrics in SAP Solution Manager reflect all alerts from SAP HANA Studio / DBA CockpitView on complete stackConfiguration Alerts(by DBA Cockpit)Availability Alerts (byHostagent)Special SAP HANAAlerts (Exceptions)(by DBA Cockpit)SAP HANAPerformance Alerts- Memory Usage- CPU Usage(by DBA Cockpit) 2013 SAP AG or an SAP affiliate company. All rights reserved.15

Monitoring “modern” BI scenario and objectsBO Web ApplicationServer SystemsSAP BI Platform Systems(BusinessObjects Enterprise)SAP Business Warehouse SAP HANA DatabasesSAP ERP Systems(SAP HANA)Systemsrunning SLT(SAP BW)Queries / TemplatesBO JobsBOE WebApplicationReportsSBOP DataServices SystemsSBOP DSInfoproviderReal Timepush - SLTProcessChainsEnd userBackend Systems/ Data Sourcese.g. SAP ERPMonitored BI objects (process chains, queries and templates in SAP BW system; jobs in BO system)Monitored systems in BI scenario – grouped by BI component type.BI monitoring scenario 2013 SAP AG or an SAP affiliate company. All rights reserved.16

Operations ControlFundamentals Training and Training on the Job while operating SAP HANA1Threshold valueexceeded!31.Utilize established SAPSolution Manager functions2.Knowledge Articles explainhow to handle exceptions3.Notifications lead to GuidedProcedures that documentthe individual steps42 Daily/weekly/monthly HANADatabase Administration tasks Handling of HANA DatabaseAlerts4. 2013 SAP AG or an SAP affiliate company. All rights reserved. and provide access torequired activities17

Guided Procedures for Manual Monitoring ActivitiesGuided procedures for regular manual checks and administration tasks for BW, SLT, and SAP HANAAccessible from technical administrationwork center – guided procedure browserIntegration with task management in development 2013 SAP AG or an SAP affiliate company. All rights reserved.18

Deployment Best Practice for SAP HANAHow to learn and incorporate it into customers IT Service ManagementGetting StartedTraining-on-the-JobExpert Guidance Self Learning Fundamental Knowledge Assets Workplace & role oriented Event based resolutionguidance Meet the expert sessions Expert Guided Implementation Individual request or issuesresolutionKnowledge AssetsSAP Solution ManagerFull Integration intoE2E Monitoring &Alerting InfrastructureIntranetGuided ProceduresGuided Self ServicesKnowledge AssetsKnowledge ArticleLearning StudioInternetSAP Enterprise Support Academy 2013 SAP AG or an SAP affiliate company. All rights reserved.SAP Backoffice19

End-to-End (E2E) Root Cause Analysis for SAP HANAE2E Change AnalysisE2E Workload AnalysisE2E Exception Analysis 2013 SAP AG or an SAP affiliate company. All rights reserved.System, Host & DatabaseAnalysisE2E Trace Analysis20

Example: HANA Server Trace 2013 SAP AG or an SAP affiliate company. All rights reserved.21

Example: Change AnalysisDatabase Changes - OverviewShows number of HANA DBparameter changes over time 2013 SAP AG or an SAP affiliate company. All rights reserved.22

Example: Change AnalysisDatabase Changes – DetailsShows singleHANA DB parameterchange history 2013 SAP AG or an SAP affiliate company. All rights reserved.23

Example: How to handleconfiguration alerts?

Sample: Handling of a Configuration Alert via Guided ProcedureThis example shows a configuration alert on the parameter log mode. Correct setting of this parameter is vital for ensuringrecoverability of the database.The screenshots also show another configuration alert due to an incorrect value for parameter Mergedog. 2013 SAP AG or an SAP affiliate company. All rights reserved.25

Handling of Configuration AlertsBoth Configuration alerts can be handled along a Guided Procedure available in SAP Solution Manager (as of SAP SolutionManager 7.1 SP8).While changing the Parameter Mergedog to its recommended Value is simple and can be performed with standard procedure forparameter changes, the change of log mode parameter requires some additional steps, e.g. performing an initial backup.Guided Procedures can be accessed from Technical AdministrationWorkcenter 2013 SAP AG or an SAP affiliate company. All rights reserved.26

Guided Procedure for changing Parameter log mode 2013 SAP AG or an SAP affiliate company. All rights reserved.27

Change Parameter ValueThe incorrect HANA Parameter can beidentified in DBACockpit.In case the Database user used inDBACockpit connection has sufficientauthorization, the Parameter changecan be performed directly inDBACockpit, otherwise access to HANAStudio is needed. 2013 SAP AG or an SAP affiliate company. All rights reserved.28

Guided Procedure tells you the full storyIn order to achieve database recoverability, not only the log mode parameter needs to be changed but also additional steps likeperforming a Backup and restarting the database are required. 2013 SAP AG or an SAP affiliate company. All rights reserved.29

Change Control Management

Main Scenarios for SAP HANA UsageScenario:HANA with 1.0,AnalyticsHANA AnalyticalPoweredbyFoundation (HAF)SAP HANAPowered byandSAPothers HANAExample:SAP BusinessSuite Powered bySAP HANA (ERP,CRM, SCM)CTS 2013 SAP AG or an SAP affiliate company. All rights reserved.Scenario:HANA without ABAPCTS 31

Which HANA content can be transported?CalculationViewsAll HANA content can be part ofa Delivery Unit.A Delivery Unit (DU) contains allobjects of the assigned packages, likeAttribute View, Calculation View, etc.Also XS Engine-Server Content(client/server JavaScript files), HTML,images, etc. can be icViews 2013 SAP AG or an SAP affiliate company. All rights reserved.js FilesImages32

Entity Model for Transportable HANA ContentHANAArtifactn 2013 SAP AG or an SAP affiliate company. All rights reserved.1Packagen1DeliveryUnit33

SAP HANA Transport Management IntegrationHANA with ABAP

What is Change and Transport Management (CTS)?Typical basic transport ationLandscapeCreateTransportRequest &ExportReleaseRequestProductiveSystem 2013 SAP AG or an SAP affiliate company. All rights inController35

SAP HANA Transport Management IntegrationMotivationBridging Two Worlds SAP HANA Artifacts not “known” by ABAP AS SAP HANA Artifacts need to be transportedtogether with ABAP Development Objects Existing Know-How in ABAP LifecycleManagement (LM)Goal ABAP LM takes the lead SAP HANA Artifacts are being imported/exportedand transported by the ABAP AS 2013 SAP AG or an SAP affiliate company. All rights reserved.ABAP LM transports SAP HANA ArtifactsABAP DevABAP LMExport SAP HANA ArtifactsSAP HANADevABAP TestImport SAP HANA ArtifactsSAP HANATest36