What Is SAP HANA Monitoring?

SAP HANA monitoring is practiced to monitor the status of system resources and services that are running in the HANA system. It is generally used to handle critical alerts like CPU usage, disk full status, FS reaching the threshold, etc.

The monitoring component of the HANA system consecutively collects information about the performance and health usage of all components of the database. An alert is raised as soon as any of the components violates the set threshold value.

The precedence of alert established in the HANA system shows the criticality of the problem and it depends on the analysis that is conducted on the component. For example, if CPU usage is 80 percent, a low-priority alert will be raised. However, if it reaches 96 percent, the system will raise a high-precedence alert.
A system monitor is the most simple way to monitor the HANA system and to confirm the availability of all your SAP HANA system components. The system monitor is used to check all key components and services of a HANA system.
Database monitoring tasks performed in the SAP HANA:

  • Monitoring status and resource usage of individual database services
  • Analyzing comparative memory utilization of column tables
  • Monitoring overall database health
  • Analyzing database performance across a range of key performance indicators related to memory, disk, and CPU usage
  • Monitoring the status of system replication (if enabled)
  • Monitoring alerts occurring in the database and analyzing the patterns of occurrence
  • Configuring the alerting mechanism, for example, changing alert threshold values, switching alert checkers on/off, and checking for alerts out of schedule
  • Analyzing the memory allocation history of all components of database services

Prepare yourself for the industry by going through this Top SAP HANA Interview Questions and Answers!

Monitoring System Availability

SAP HANA’s operational status can identify its availability. It can be accessed by entering the system view present in the system monitor.
The status of the services of an SAP HANA Studio can be determined through an SQL connection or SAP Start Service.
The operational status of a system in SAP HANA Studio can be seen in the following places:

  • System monitor
  • Overview tab of the Administration editor
  • System view

Services involved in the SAP HANA system are:

  • Preprocessor
  • Indexserver
  • Nameserver
  • Compileserver

If you have any doubts or queries related to SAP HANA, get them clarified from the SAP experts on our SAP Community!

Error Situations

The availability of the system can be interrupted by error situations regardless of their operational status. A system appears in the system view with an error icon () in the following situations:

  • The connected user is invalid.
  • An SQL connection isn’t available.
  • The SAP HANA license is invalid.
  • The SAP HANA system is functioning as a second instance of your primary system, (e.g., in a high-availability scenario).
  • The SAP HANA system is renamed.

SAP Start Service Unreachable

It is an error that can be indicated if ‘sapstartsrv’ can’t be reached. In this case, where all the other services are working, the system itself is accessible and operational.
There may be numerous reasons as to why ‘sapstartsrv’ isn’t reachable. First, we should check if it is running. We can do so by simply investigating the connection to the web service in a web browser.
Enter the following URL to get the web service description (WSDL) from ‘sapstartsrv’ of an SAP HANA system:

http://<host>:5<instance_number>13/?wsdl

For a secure connection, enter:

https://<host>:5<instance_number>14/?wsdl

If you receive an XML output that starts with definitions name=”SAPControl”, then the connection is working.

Kick-start your career in SAP HANA with the perfect SAP HANA Training Course now!

Monitoring Alerts

If you’re an administrator, you should actively monitor the status of the system with its services and the consumption of system resources. Yet, one can also be alerted of the critical situations such as a disk becoming full or the CPU usage reaching a critical level.
An internal monitoring infrastructure of the SAP HANA database has a continuous work of collecting and evaluating information about performance, status, and resource usage from all components of the HANA database. It also performs routine checks on the data in system tables and views. Whenever configurable threshold values are surpassed, alerts are immediately issued. A warning is sent for potential problems. Alerts are set priority-wise, i.e., the severity of the problem depends on the nature of the check and configured threshold values. For example, if 90 percent of the available disk space is used, a low-priority alert is issued; whereas if it reached 98 percent, a high-priority alert is issued.
Alerts are displayed according to the following time periods:

Time PeriodAlerts Displayed
Last 15 minutes, last 30 minutes, last hour, last 2 hours, and todayAlerts generated in the corresponding time periods are shown. If an alert was generated 10 minutes ago, it appears under all these headings.
YesterdayOnly alerts that were generated yesterday are shown.
Last weekOnly alerts generated during the previous week (Sunday to Saturday) are shown.
Two weeks ago, and so onOnly alerts generated during those respective time periods are displayed.

The list of displayed alerts can be refined further by specifying filters as follows:

  • To filter according to additional attributes including priority and date of occurrence, choose the (Filters) button in the toolbar on the top-right of the tab and select the required filter(s)
  • To filter according to a specific word in the check description, enter the word in the Filter field (e.g., license)

Wish to get certified in SAP HANA! Learn from our SAP HANA expert and do excel in your career with intellipaat’s SAP HANA Admin certification!

In this session of the SAP HANA tutorial, we learned about SAP HANA monitoring. Stay tuned with us for more!

Recommended Videos

Leave a Reply

Your email address will not be published. Required fields are marked *