Monitoring an SAP HANA Cloud, SAP HANA Database
- 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
Christopher KollhedMarch 21, 2022
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
If you feel familiar with SAP HANA cockpit from using it with your SAP HANA on-premise database, you can skip this tutorial and
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.
Log in to complete tutorial