Monitoring an SAP HANA Cloud, SAP HANA Database

If you feel familiar with SAP HANA cockpit from using it with your SAP HANA on-premise database, you can skip this tutorial and _☛jump to the next one to learn about provisioning.

SAP HANA cockpit is your main tool to manage and monitor your SAP HANA Cloud, SAP HANA databases.

Using SAP HANA cockpit, you can monitor your database metrics to be able to analyze and improve performance. While SAP is responsible for monitoring both the hardware, virtual machines, and operating systems, as well as health, it is important that you monitor the operation of SAP HANA databases on a regular basis. You will learn how to access and use SAP HANA cockpit throughout the next sections of this module.

Although SAP HANA actively alerts you of critical situations, keeping an eye on resource usage and performance will help you identify patterns, forecast requirements, and recognize when something is wrong.

In SAP HANA cockpit, you can monitor…

• overall database health
• status and resource usage of individual database services
• database performance across a range of key performance indicators related to memory, disk, and CPU usage
• comparative memory utilization of column tables
• memory statistics of the components of database services
• alerts occurring in the database to analyze patterns of occurrence

Performance Monitoring Tools

SAP HANA cockpit allows you to monitor past and current information related to your database in fine-grained detail. Various tools exist to help you monitor performance in order to analyze and improve performance for your database.

In the Monitoring View, you can see several cards that help you access these tools.

• The Performance Monitor helps you to visualize historical performance data related to memory, disk, and CPU usage. Here, you can compare performance of different KPI’s and trigger the collection of diagnosis information if you identify issues. You can open it by clicking on Monitor performance on the Monitoring card. Read more here.

• The Threads card shows you the longest-running threads in your system and lets you filter by different parameters. Read more about Thread Details here.

• The Sessions card allows you to analyze sessions connected to your database and their SQL execution. Read more here.

• The SQL Statements Monitor gives you several insights about the SQL statements running in your database. On the SQL Statements card, click on View all to see the different Monitoring tools available there: Active Statements, SQL Plan Cache and Expensive Statements.

To read more about all available tools to monitor, analyze and improve performance, please refer to this technical documentation on performance monitoring.

To understand in detail the difference of monitoring and managing your database with the SAP HANA cockpit, you can take a look at the following videos, created by the SAP HANA Academy team.

In this video tutorial, you can check out the information provided by the System Information card on the SAP HANA cockpit for SAP HANA Cloud and compare this to what this card would show on an on-premise system (SAP HANA platform edition) and the previous SAP Business Technology Platform, SAP HANA Service (Cloud Foundry).

For further information, have a look at the companion blog post in the SAP Community.

In this video tutorial, you will see the information provided by the Overall Database Status card and the Manage Services view on the SAP HANA cockpit for SAP HANA Cloud and compare this to an on-premise system (SAP HANA platform edition) and the previous SAP Cloud Platform, SAP HANA Service (Cloud Foundry).

You can also check out the companion blog post in the SAP Community.

In this video tutorial, you can get to know the Alerts card on the SAP HANA cockpit for SAP HANA Cloud.

Read more in the companion blog post in the SAP Community.

In this video tutorial, you can see how to work with the CPU | Memory | Disk Usage and Monitoring cards on the SAP HANA cockpit for SAP HANA Cloud with the associated apps:

• Performance Monitor
• Performance Comparison
• Workload Analysis
• Memory Analysis
• Buffer Cache Monitor
• and Memory Paging Monitor

Read more in the companion blog post in the SAP Community.

If you have used the HANA Cockpit Replication Service to set up replication of remote objects, e.g. from an SAP HANA on-premise database. You can monitor these replication objects on the Replication Services Card.

Read more about this in the blog post in the SAP Community.

You can find the technical documentation about Replication Service here.

In this video tutorial, you can see how to work with Sessions, Threads, Blocked Transactions and related apps like Monitor Statements on the SAP HANA cockpit for SAP HANA Cloud.

You can also check out the companion blog post in the SAP Community.

Well done!

You have completed the third tutorial of this mission! Now you know the basics about monitoring your databases in SAP HANA Cloud, SAP HANA database.

Learn in the next tutorial how to provision an instance of SAP HANA Cloud, SAP HANA database.