Skip to Content

Monitoring an SAP HANA Cloud, SAP HANA Database

test
0 %
Monitoring an SAP HANA Cloud, SAP HANA Database
Details

Monitoring an SAP HANA Cloud, SAP HANA Database

Learn what you can monitor in SAP HANA Cloud, SAP HANA database and how to do that in SAP HANA cockpit.

You will learn

  • What SAP HANA on-premise and SAP HANA Cloud, SAP HANA database have in common
  • What the differences between on-premise and cloud service are
  • What tools to use with SAP HANA Cloud, SAP HANA database
QR code

With SAP HANA Cloud, you can manage your databases with the SAP HANA cockpit, just as you do with your SAP HANA on-premise databases. Of course, managing your cloud databases is a little different from your on-premise ones. For example, your system updates are managed for you in SAP HANA Cloud.

Important to know is that, even though you will manage your SAP HANA Cloud database with the SAP HANA cockpit, for the short term, you will need two different instances of the cockpit: one for your on-premises databases and another for the cloud databases.

This tutorial will give you an overview of the main differences between SAP HANA on-premise and SAP HANA Cloud, SAP HANA database in terms of monitoring.


Step 1: Introduction to SAP HANA Cockpit

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.

Monitoring 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.

Statement Monitor

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

Log on to answer question
Step 2: System Information in SAP HANA Cockpit

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.

Log on to answer question
Step 3: Manage Services in SAP HANA Cockpit

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.

Log on to answer question
Step 4: Alerts in SAP HANA Cockpit

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.

Log on to answer question
Step 5: Monitoring in SAP HANA Cockpit

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.

Log on to answer question
Step 6: Monitoring Replication Services in SAP HANA Cockpit

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.

Log on to answer question
Step 7: Monitoring Sessions, Thread, and Statements in SAP HANA Cockpit

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.

Log on to answer question
Step 8: Test yourself
What is the name of the tool to use for monitoring your SAP HANA Cloud, SAP HANA database?
×

Next Steps

Back to top