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).
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.
|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, execute the steps described here.
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.
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.
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.
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, 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.
On the database instance level, there are four SAP HANA DB Instance templates.
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.
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.
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.
Note: 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 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).
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.
|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 the 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 the 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 these changes as the SQL itself might contain 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.