SAP HANA Monitoring

The SAP HANA Operations page provides relevant information, from how to connect SAP HANA database to SAP Solution Manager 7.2 (including technical configuration on the HANA side and Managed System Configuration on the SAP Solution Manager side), up to setup and usage of Application Operations scenarios (which SAP Solution Manager offers for operating SAP HANA, such as System Monitoring, Root Cause Analysis, Guided Procedures and SAP EarlyWatch Alert).

Supported Functions

  • Monitoring for HANA with standalone statisticsserver: Since HANA SPS9, no new HANA metrics are provided for standalone statisticsserver.
  • Monitoring for HANA with embedded statisticsserver: As of HANA Rev 96, embedded statisticsserver is default for all SAP HANA systems.
  • Advanced Monitoring Metrics in Solution Manager (Solution Manager only metrics): Provides future HANA metrics for older HANA revisions.
  • Replication scenario in monitoring UI: Replication metrics can also be used w/o the new UI.
  • E2E Workload/Change/Exception Analysis: Additional content with newer Solution Manager SPs.
  • E2E Trace: HANA >= SP6, Clients versions (ABAP >= 7.40, BI >= 4.2, Lumira desktop >= 1.0.7).
  • EarlyWatch Alert: ST-PI 2008_1_7xx SP 10 or ST-PI 740 on ABAP (for ABAP on HANA) or on SolMan (for standalone HANA).
  • SLT Monitoring: DMIS 2010 >= SP6 or 2011 >= SP1, see SAP Note 2081759.
  • HANA tenant DB monitoring: SP>=SP5.

Data Collection

The data for most of the HANA metrics is collected via the DBA Connection between SAP HANA and SAP Solution Manager. This connection is created during the managed system setup of the SAP HANA database.

The metrics for the OS level templates are collected by the SAP Hostagent and delivered by the SAP Diagnostics Agent.

Prerequisites and Setup

Solution Manager (ST)

The following notes need to be implemented in SAP Solution Manager:

All Solution Manager SPs:

  • 1597627 - HANA Client Installation on Solution Manager
  • 1983628 - DBACOCKPIT for HANA: Failover ability
  • 1952701 - DBSL supports new SAP HANA SP9 version number 

 

SAP Solution Manager 7.2

SP SAP Notes
Solution Manager 7.2 SP 03
  • 2211415 - Alerting composite
  • 2008396 - ST-PI: E2E Datacollectors for HANA
  • 2066155 - Amount of extracted data too high for HDB HOST SQL PLAN CACHE
  • 2398993 - Configuration check in Managed System Configuration fails for systems with virtual HANA DB
  • 2549432 - Improvements for HANA metric validity checks
  • 2440487 - Issues with metric collector parameter usage
Solution Manager 7.2 SP 04

 

  • 2211415 - Alerting composite
  • 2008396 - ST-PI: E2E Datacollectors for HANA
  • 2066155 - Amount of extracted data too high for HDB HOST SQL PLAN CACHE
  • 2177195 - HANA metrics validity checks
  • 2398993 - Configuration check in Managed System Configuration fails for systems with virtual HANA DB
  • 2549432 - Improvements for HANA metric validity checks
  • 2440487 - Issues with metric collector parameter usage

 

Solution Manager 7.2 SP 05
  • 2211415 - Alerting composite SAP Note 
  • 2008396 - ST-PI: E2E Datacollectors for HANA2177195 - HANA metrics validity checks
  • 2549432 - Improvements for HANA metric validity checks
  • 2440487 - Issues with metric collector parameter usage
Solution Manager 7.2 SP 06

 

  • 2211415 - Alerting composite
  • 2008396 - ST-PI: E2E Datacollectors for HANA
  • 2549432 - Improvements for HANA metric validity checks
  • 2440487 - Issues with metric collector parameter usage

 

Solution Manager 7.2 SP 07
  • 2211415 - Alerting composite
  • 2008396 - ST-PI: E2E Datacollectors for HANA

Managed System (ST-PI)

The following notes are needed in the managed system. The notes depend on the managed system type:

SLT

  • ST-A/PI 01P*: SAP Note 1743562 - ST-A/PI 01P: SLT Monitoring requires manual corrections 

SAP BW on HANA

SAP HANA and Operating System

The following notes are relevant for SAP HANA itself and for the agents on the operating system level:

SAP HANA

  • SAP Note 1542651 - EarlyWatch alert for HANA: Service data collection
  • SAP Note 1598623 - SAP HANA appliance software: Central Security Note
  • SAP Note 2111428 - Embedded statistics service check 31 (Alert_License_Expiring) does not return the value DAYS_BEFORE_LICENSE_EXPIRATION in Rev. 74 
  • SAP Note 2303938 - Wrong DB name in System Landscape Directory (for SAP HANA database Revision 110 - 122.01)

HANA Studio

  • SAP Note 1896320 - Error occurred while trying to start SAP HANA Lifecycle Manager 

Operating System Level

SUM for SAP HANA

Corrections for SLD Support for SAP HANA

  • SAP Note 1673424 - Associate support package for SAP_InstalledKernelComponent
  • SAP Note 1649323 - SLD: HANA database enhancement (when ABAP on HANA is used – makes SAP Note 1673424 unnecessary)

Setup for SAP HANA Database

Before you start to perform a setup for SAP HANA in SAP Solution Manager 7.2, execute the steps described here.

Available Templates and Metrics

All metrics are in general available as of SAP Solution Manager 7.2 SP1. The metrics are shipped with the MAI content in ST-CONT. You can find an XLS spreadsheet with all metrics here.

To make sure you have all metrics available, make sure you applied the latest version of the MAI content via step 2.7 - Update Content in the System Monitoring setup.

It is very important that after a content update in SOLMAN_SETUP you also update SAP Note 2211415 and SAP Note 2008396 in SAP Solution Manager transaction SNOTE. These notes contain the latest coding to make sure the metrics are collected correctly and the result types match the MAI content.

You will find that several metrics have prefixes and are shipped inactive. The reason for this is that we added several metrics that are specific for certain HANA options to the templates. The following metrics are use-case specific and should only be activated if you run the use-case.

  • SR - Metrics relevant for system replication
  • DT - Metrics for HANA Dynamic Tiering
  • DP - Metrics for Data Provisioning (Part of Smart Data Integration)
  • DS - Metrics are only relevant for Smart Data Streaming
  • SDI - Metric relevant for Smart Data Integration

SAP Solution Manager offers several SAP standard monitoring templates for SAP HANA. The usage of those templates depends on the exact scenario. Which templates to use and the difference between them, is described in this chapter.

Over the past years, the scope of SAP HANA monitoring supportability has been continuously enhanced. Started with a monitoring template for a single SAP HANA DB (current shipped as SAP HANA DB (OLD)), later introducing the SAP HANA (NEW) template, followed by the templates for HANA instances, system replication and finally the MDC.
 

SAP Solution Manager 7.2 SP3 and higher

Starting with the support package stack 3 and higher, the following SAP HANA templates are available to cover the monitoring for SAP HANA 1.0 and 2.0, except those for the tenant DB. The MDC templates have been shipped starting with SP5.
 

Templates on Database Level

On the database level, three SAP templates are available:

  • SAP HANA DB (NEW): This templates contains all metrics available for SAP HANA. It also contains metrics that can be potentially collected on the database instance level. Do not apply this template and the SAP HANA template on the database instance level (SAP HANA DB Instance (instance level separated)) together. If you apply these two templates together the metrics that can be collected on the instance level will be collected twice. Once on the database level and again on the database instance level.
  • SAP HANA DB (OLD): This template also contains all metrics but just grouped differently. Same as for the first one, also this template should not be applied together with the instance specific template.
  • SAP HANA DB (instance level separated): This template contains only metrics that cannot be collected on the database instance level. Use this template together with the SAP HANA DB 1.0/2.0 Instance (instance level separated) template on the database instance level.

Background: The difference between SAP HANA OLD and NEW is the way the metrics are grouped in the template. In the older template, the metrics are grouped under very few but generic alerts, such as the HDB Space Management alert that contains different metrics related to space management in HANA.

The new one is closer to the actual structure of the alert in HANA. For each alert in HANA there is one alert in the template with the respective metric. This makes it easier to see with one alert what is going on. Also, the Guided Procedures are now assigned to a single alert. We have several Guided Procedures to address HANA alerts and they are assigned to the respective alert in the SAP HANA DB (NEW) template.

The difference between the templates only exists for the metrics based on HANA alerts. The metrics collected by SAP Solution Manager additionally using the HANA Database Metrics collector exist the same way in both templates.

The recommended approach is also to use the SAP HANA DB (NEW) template.
 

Templates on the Database Instance Level

On the database instance level, there are four SAP HANA DB Instance templates.

  • SAP HANA DB 1.0 Instance
  • SAP HANA DB 1.0 Instance (instance level separated)
  • SAP HANA DB 2.0 Instance
  • SAP HANA DB 2.0 Instance (instance level separated)

The (instance level separated) templates contain metrics, which can be separated by host, in HANA's case by HANA node. These templates should only be applied in a combination with the SAP HANA DB (instance level separated) template on the database level.

Another two template just contain instance-aware metrics and show the metrics values filtered by instance. Apply this template together with (NEW) or (OLD) from the DB level.

Note: The monitoring of the HANA DB instances has been originally introduced with SAP Solution Manager 7.1 SP14.
 

Templates on the Database Replication Group Level 

If you have a SAP HANA system with a system replication setup, you can assign the SAP HANA DB 1.0/2.0 Replication Group template to the virtual database which marks the entry point to the system replication group. This template contains metrics and alerts that are relevant for the SAP HANA system replication scenario. Alternatively, instead of this template, you can activate the system replication specific metrics in the templates on the database level. System replication specific metrics have the prefix ‘SR' on the database level template. 

Note: The monitoring of the HANA DB replication was originally introduced with SAP Solution Manager 7.1 SP14. Currently, only the 2-tier replication scenario is covered by the system monitoring. The support of the 3-tier scenario is planned to be added in one of the next SPs.
 

Templates on the Tenant Database Instance Level 

As of SP5, the SAP standard templates for MDC can be found under the Tenant Database Instance. These are identical with the templates from the instance level and should be used in the same way as the instance templates.

  • SAP HANA DB 1.0 Tenant Instance
  • SAP HANA DB 1.0 Tenant Instance (instance level separated)
  • SAP HANA DB 2.0 Tenant Instance
  • SAP HANA DB 2.0 Tenant Instance (instance level separated)

Note: Starting with SAP HANA 2.0 SPS 01, MDC will be the only operational mode for SAP HANA systems.

Activating System Monitoring

The activation of Technical System Monitoring is done similarly as all other technical systems. Go to SOLMAN_SETUP > Application Operations > System Monitoring > Step: Define Scope and select your HANA system or your ABAP on HANA system. Assign the required templates for SAP HANA and activate it.  

Note: For more information regarding the initial setup of system monitoring and further configuration steps, refer to the System Monitoring - Setup and Configuration area.

After successful activation, the result can be seen in the System Monitoring UI. To open this UI, click the System Monitoring tile in the SAP Solution Manager launchpad and specify the relevant scope (e.g. the SID of your HANA system).


Metrics Configuration

As with all monitoring, you might want to change certain settings on a metric such as the threshold or the collection period. In case of SAP HANA this is not necessarily straight forward, as we have different ways how we collect the metrics and where values are rated. Some metrics are already rated in SAP HANA so they do not have a threshold to change in SAP Solution Manager.

The minimum collection period for SAP HANA metrics is five minutes. The reason for this is that the metrics are collected via pull RFC through the DB connection and this extractor cannot run more frequent than every five minutes.

In general you should be careful with changes to the collection period as this can change the behavior and hence the meaning of a metric.

MetricCollection MethodThreshold ChangesCollection Period Changes
Metric ID is < 1000 and the threshold is Already RatedCollected from an existing alert in HANA (rated in HANA)SAP HANAChange in SAP HANA and adjust in SAP Solution Manager template
Metric ID is < 1000 and the threshold is set in the Solution Manager templateCollected from an existing alert in HANA (values collected from HANA and rated in Solution Manager)SAP Solution ManagerChange in SAP HANA and adjust in the SAP Solution Manager template
Metric ID is >= 1000Collected via SQL request to SAP HANA, values rated in Solution ManagerSAP Solution ManagerChange in SAP Solution Manager template (Be careful with these changes as the SQL itself might contain a time definition, e.g. values for last hour)

Metrics Consistency Check

With the latest version of SAP Note 2211415 we ship an application within DBACOCKPIT that allows you to compare the thresholds between SAP HANA and SAP Solution Manager.

As a prerequisite for this tool the SAP HANA database must be connected to SAP Solution Manager successfully and the System Monitoring must have been activated and carried out at least once.

  • Open the DBACOCKPIT transaction then select the SAP HANA system you want to check. Select Self-Monitoring and check if you see the Check for Thresholds of Alerts and Metrics alert.
  • Double-click  the alert and switch to the Repair Tool.
  • In the next screen you will see an overview of the settings in SAP HANA and SAP Solution Manager. Switch to Edit mode to change the settings in SAP HANA.
  • You cannot change the settings in SAP Solution Manager here, as the template can be used by more than one SAP HANA system. To change the settings in SAP Solution Manager, switch to the Technical Monitoring Template Management.