SAP HANA Monitoring

SAP HANA is a type of database (in-memory) that performs real time analysis of data. The SAP HANA database also develops applications that are on the top of the real time data. The HANA administration is in charge of managing the SAP HANA system in a distributed as well as a single system environment.

Every single one of the HANA systems contains architecture that is multi node. Each security node contains several processors for data analysis at a high speed.

The multiple nodes are also in charge of providing real time data. In order to get the real time data from non-sap systems, you can use Smart data access and avoid the process of importing the data to the HANA database. Virtual tables would come in handy when using the Smart data access to perform read and write data operations.

Some of the activities included in the SAP HANA administration include:

• • The SAP HANA life cycle management
  • The SAP HANA multiple host system management
  • The SAP HANA administration tools
  • The SAP HANA security and user management

• The SAP HANA data provisioning and integration with non -sap systems
• The SAP HANA system management and availability
• The SAP HANA backup and recovery management

Each of the sap systems contain multiple servers, which are accessible for survey in the HANA studio under the administration tab. This SAP HANA studio contains a default administration perspective in order to deploy all the tasks of administration in the HANA systems.

Image courtesy of Avantra – https://www.avantra.com/sap-hana-performance-monitoring

How will sap monitoring benefit your organization?

The great thing about the system monitor offered by the HANA studio is that it provides an outline of your entire HANA system. The system monitor allows you to have analytic privileges of the details of a single system in the administration editor. The administration editor contains the following information:

• Trace disk- the size of the trace files on the disk (measured in gigabytes).
• Log disk – it refers to the size of the log volume on the disk (measured in gigabytes).
• Data disk- this is the size of the volume of data on the disk (measured in gigabytes).
• Alerts on priority resource usage

The SAP HANA system monitor

Information available in the SAP HANA system monitor includes:

System ID

This refers to the ID assigned to the system when you add it into your business.

Operational state

This is the general status and order of the system.

Alerts

In the event that a violation occurs in the resource usage or the statistical thresholds, the system will issue an alert to inform you of the violation. The alerts can be low, medium, or high priority depending on the problem at hand. The system also issues information alerts in case there is need of an update.

Database resident memory

It is the size of the resident memory at the level of the operating system due to the SAP HANA database processes.

System resident memory

This is the entire size of the resident memory in the operating system.

Used memory

It refers to the amount of physical memory used by the SAP HANA studio.

Number of crash dump files

This is information about the number of crash dump files in the trace directory of the SAP HANA system.

Platform

It is the operating system, which the SAP HANA studio runs in.

How to monitor sap databases

The SAP HANA monitoring system is mainly for monitoring the status of services and system resources that run in the HANA system. You can use the SAP HANA alert monitoring to audit the system for potential issues in CPU usage, FS reaching its threshold, and disks becoming full among other HANA security overview issues.

The SAP HANA monitoring and troubleshooting system collects information about the performance, usage, and health of the components in the HANA database. When any of components breach the set threshold value, the system raises an alert.

The priority of a raised alert informs you of the criticality of the problem at hand. The problem’s criticality depends on the security check performed by SAP HANA on the component. For example, if the CPU usage is at 80 percent, you will likely receive a low priority alert. However, if days go by and the CPU usage rises to 96 percent, the HANA system will raise a top priority alert to warn you.

Cost of the SAP HANA monitoring system

The estimated cost for a single SAP HANA system is around 15 USD per month. This price does not factor in any free tiers that may be on offer. The number of existing custom metrics mainly drives the SAP HANA system costs.

Requirements a sap system user should meet

There are basic software and hardware requirements you must meet before using the SAP HANA system. Below are some of the requirements:

Free space

In order to use the sap system, you will require a minimum of 20 gigabytes free space on your computer. Any storage capacity less than 20 gigabytes will not be able to support the SAP HANA program and its features.

RAM

For your computer to support the architecture of the sap system, you will require a RAM of not less than 64 giga bytes. If possible, get 128 gigabyte RAM for maximum performance.

Storage drives

The size of RAM you use will determine the size of your storage drive. For maximum performance of the SAP HANA system, use a storage drive that is twice the size of the RAM count.