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 HANA side and Managed System Configuration on SAP Solution Manager side), up to setup and usage of Application Operations scenarios, which SAP Solution Manager offers for operating SAP HANA, like System Monitoring, Root Cause Analysis, Guided Procedures and EWA.
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
The following notes need to be implemented in SAP Solution Manager:
All Solution Manager SPs:
|Solution Manager 7.2 SP 03||
|Solution Manager 7.2 SP 04||
|Solution Manager 7.2 SP 05|
|Solution Manager 7.2 SP 06||
|Solution Manager 7.2 SP 07|
The following notes are needed in the managed system. The notes depend on the managed system type:
SAP BW on HANA
The following notes are relevant for SAP HANA itself and for the agents on the operating system level.
Operating System Level
SUM for SAP HANA
Corrections for SLD Support for SAP HANA
Before you start to perform a setup for SAP HANA in SAP Solution Manager 7.2 please execute the steps decribed on the Managed System Setup for SAP HANA.
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 please make sure you applied the latest version of the MAI content via the 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 the two SAP notes 2211415 and 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 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.
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 when and what are 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.
Starting with the support package stack 3 and higher all below mentioned 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.
On the database level three SAP templates are available:
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, like the alert "HDB Space Management" 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.
On database instance level, there are four templates "SAP HANA DB Instance".
The (instance level separated) templates contain metrics, which can be separated by host, in HANA's case by HANA node. This templates should be only applied in a combination with "SAP HANA DB (instance level separated)" template on database level.
Another two template just contain instance aware metrics and show the metrics values filtered by instance. Please apply this template together with (NEW) or (OLD) from the DB level.
Remark: the monitoring of the HANA DB instances has been originally introduced with SAP Solution Manager 7.1 SP14.
If you have a SAP HANA system with a system replication setup you can assign the template "SAP HANA DB 1.0/2.0 Replication Group" to the virtual database which marks the entry point to the system replication group. This template contains metrics and alerts that are relevant for SAP HANA system replication scenario. Alternatively, instead of this template, you can also activate the system replication specific metrics in the templates on database level. System replication specific metrics have the prefix ‘SR' on the database level template.
Remark: the monitoring of the HANA DB replication has been originally introduced with SAP Solution Manager 7.1 SP14. Currently only 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 SP.
Under the Tenant Database Instance, the SAP standard templates for MDC can be found. Available as of SP5. As it can be assumed, based on the template naming, they are identical with the templates from the instance level and should be used in the same way as the instance templates.
Remark: Starting with SAP HANA 2.0 SPS 01, MDC will be the only operational mode for SAP HANA systems.
The activation of Technical System Monitoring is done as for all other technical system. 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, please 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, please click on the "System Monitoring" tile in the SAP Solution Manager launchpad and specify the relevant scope (e.g. the SID of your HANA system).
As with every monitoring you might want to change certain settings on a metric like 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 don't have a threshold to change in SAP Solution Manager.
The minimum collection period for SAP HANA metrics is 5 minutes. The reason is that the metrics are collected via pull RFC via the DB connection and this extractors cannot run more frequent than every 5 minutes.
In general you should be careful with changes to the collection period as this can change the behaviour and hence the meaning of a metric.
|Metric||Collection Method||Threshold Changes||Collection Period Changes|
|Metric ID is < 1000 and the threshold is "Already Rated"||Collected from an existing alert in HANA (rated in HANA)||SAP HANA||Change in SAP HANA and adjust in SAP Solution Manager template|
|Metric ID is < 1000 and the threshold is set in Solution Manager template||Collected from an existing alert in HANA (values collected from HANA and rated in Solution Manager)||SAP Solution Manager||Change in SAP HANA and adjust in SAP Solution Manager template|
|Metric ID is >= 1000||Collected via SQL request to SAP HANA, values rated in Solution Manager||SAP Solution Manager||Change in SAP Solution Manager template (Be careful with this changes as the SQL itself might contains a time definition, e.g. values for last hour)|
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.