Interview Questions

SAP HANA Monitoring

The current status and existence of the SAP HANA system in term of its resources and services are tracked and understood with the help of SAP HANA monitoring. The system uses alert monitoring is used to handle the critical issues like CPU usage, disk full, FS reaching threshold and alerts the administrator for resolve. This exclusive component of SAP HANA system continuously keeps storing the information about the performance, health, usage and processes of all the components of HANA database. Whenever it identifies a breach, it raises an alert signaling the exceeding threshold value.

Based on the criticality of the issue, the SAP HANA system sets the priority for every alert raised during the monitoring. For instance, high priority is given to the alerts on CPU usage exceeding 90% than the alert raised for exceeding 80%.

System Monitor

The System Monitor is the most common way to monitor SAP HANA system and to administer the availability of various resources and components of the SAP HANA system. System monitor is used to checking all key component and services of a HANA system. Administration Editor in the system reveals information about the Data Disk, Log disk, Trace Disk, alerts on resource usage with priority. Alert tab in Administrator editor is used to check the current and all alerts in HANA system which also notifies the time when the priority or alert is raised.

Following are the different alerts notified by the SAP HANA monitoring dashboard on the system health and configuration,

High and Medium priority alerts.
Memory and CPU usage
Data backups

Following are the default information provided by the SAP HANA monitoring dashboard,

System status	It notifies overall health of the system. The possible System status values are, Running: All services are running. Running with issues: All services are running, but there are high-priority alerts. Not running: One or more services are not started. For multiple host systems, the status of individual worker hosts is also indicated.
Alerts	It specifies the number of current high- and medium-priority alerts in the system
Used memory	This is the total amount of memory currently used by the SAP HANA database in relation to the allocation limit For multiple-host systems, values are aggregated across all worker hosts. The host with the highest (most critical) memory usage is also shown. The bars indicating memory usage change color (gray, orange, and red) based on the thresholds of check 1.
CPU usage	Percentage of CPU currently used by the SAP HANA database compared with the operating system as a whole For multiple host systems, values are aggregated across all worker hosts. The host with the highest (most critical) CPU usage is also shown. The bars indicating CPU usage change color (gray, orange, and red) based on the thresholds of check 5.
Disk usage	Indicator of disk usage on disks by data, log, and trace files belonging to the SAP HANA database The bars indicating disk usage change color (gray, orange, and red) based on the thresholds of check 2.
System restarts	Number of services that have been manually or automatically restarted
Query load	Number of currently blocked transactions in the system, as well as expensive statements recorded by the expensive statements trace
Active sessions	Number of current running and idle sessions in the system
Running jobs	Number of jobs currently in progress
Backups	Current status of data and log backups
Number of dumps	Number of dump files in the system's trace directory
System replication status	System replication status, if configured
General system information	System version, time of the last upgrade, and hardware information