During my SAP HANA classes I often get the question “How should I monitor the SAP HANA systems?” I think that is a good question and in this blog I want to explain how you can monitor your SAP HANA systems.

The monitoring options for SAP HANA systems

As an SAP System Administrator you need to keep your SAP HANA systems up and running. So what would be an good way of doing this? There are two options and depending on your needs and available infrastructure you should decide which option suits you best.

  • You can monitor you SAP HANA systems using SAP HANA Studio
  • You can monitor you SAP HANA systems using SAP Solution Manager

Monitoring SAP HANA systems using SAP HANA Studio

This solution is best for customers that have no SAP ABAP footprint. The monitoring can be done using the monitoring tools included in SAP HANA Studio. Using SAP HANA Studio you can monitor the following areas:

  • Overall System Status using the System Monitor view
  • Detailed System Status using the Default Administration view
  • Memory usage per system or service using the Memory Overview view
  • Resource usage using the Resource Utilization view
  • System Alerts using the Alert view
  • Disk Storage using the Volumes view
  • Overall view using the SAP HANA Monitor Dashboard

Overall System Status using the System Monitor view

In the System Monitor you will find an status overview of all the SAP HANA systems connected to your SAP HANA Studio. As you can see in the screenshot below it shows the system status including some important metrics. With this monitor you can quickly see if all systems are functioning within normal specifications.

SAP_HANA_System_Overview.png

Detailed System Status using the Default Administration view

In the Detailed System Status view you get an detailed overview of the most important metrics from the selected SAP HANA system. With this information you can see if all the different areas (memory, CPU and disk) are running within the given thresholds. If not you can follow the links for an deeper investigation.

SAP_HANA_Admin_Overview.png

Memory usage per system or service using the Memory Overview view

I think that memory usage is one of the most important metrics in an SAP HANA system. That is why there are several nice views available to show the overall memory usage and the the usage per service. These views also give the option to look at the memory usage in an specified time period.  This can be very useful to investigate what happened last night.

Memory Overview per System

SAP_HANA_Memory_Overview.png

Memory Overview per Service

SAP_HANA_Service_Monitor.png

Resource usage using the Resource Utilization view

The resource monitor lets me look at CPU, memory and storage metrics in an combined view. It also show me the graph in an specified time period. Using this monitor give me the opportunity to find the root cause of the problem.

SAP_HANA_Resource_Utilization.png

System Alerts using the Alert view

The System Alerts view show all the alerts that have been triggered in the system. I can specify my own thresholds values and for the alters that I think are important I can setup email notification. With is email notification I get informed on important alerts even when I’m looking after other systems.

SAP_HANA_Alert_View.png

Disk Storage using the Volumes view

Even in an In-Memory database disk storage is important, so using the Volumes view you can keep track of the filling level and the IO performance.

SAP_HANA_Volumes_View.png

The SAP HANA Monitoring Dashboard

As of SAP HANA SPS08 the is also an Administration Dashboard available that show the most important metrics in a SAP Fiori Dashboard.

SAP_HANA_Dashboard.png

I have also recorded a video showing all the SAP HANA Studio monitoring features.

Monitoring SAP HANA systems using SAP Solution Manager

This solution is best for customers that use SAP Solution Manager already for managing and monitoring SAP systems. SAP HANA is added to SAP Solution Manager as a Managed System and from there you can setup Technical System monitoring. The Maintenance Optimizer (MOPZ) and DBACOCKPIT are also fully operational.

Using the transactions SM_WORKCENTER and DBACOCKPIT gives as many monitoring capabilities (maybe even more) than what is possible in SAP HANA Studio.

I have created a few video’s to demonstrate the transactions SM_WORKCENTER, the The Maintenance Optimizer (MOPZ) and DBACOCKPIT.

Monitoring SAP HANA using transactions SM_WORKCENTER


This video shows how you can monitor SAP HANA system using SAP Solution Manager 7.1 SP12

Monitoring SAP HANA using transaction DBACOCKPIT

This video shows the transaction DBACOCKPIT in a SAP Solution Manager 7.1 SP12 connected to a SAP HANA system.

Requesting an SAP HANA Support Package Stack using MOPZ

This video show how you can use SAP Solution Manager 7.1 sp12 to request and download an Support Package Stack for SAP HANA.

If you want to learn more on SAP HANA and SAP Solution Manager then visit the SAP Education website. There is a curriculum for SAP HANA Administration and SAP Solution Manager.

You can also visit the SAP Leaning Hub and have a look in my SAP Leaning Room “SAP HANA Administration and Operations”.

SAP_HANA_Learning_Room.png

Have fun watching over SAP HANA

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Henricus Bouten Post author

    The Metric² looks very nice too, but the SAP HANA Monitoring Dashboard is already in SAP HANA as it is developed by SAP.

    The SAP HANA Monitoring Dashboard can be used inside SAP HANA Studio or on a browser/tablet/smartphone. As of SAP HANA SPS08 the SAP HANA Monitoring Dashboard is available by default.

    To use it, just add the role sap.hana.admin.roles::Monitoring to your admin user account and open up a browser and go over to the URL for accessing the monitoring dashboard is:

    http://<hana server>:<xs port>/sap/hana/admin/ui

    (0) 
  2. John Appleby

    Thanks Hay, nice post. I think you will find that SPS09 gives us some new toys to play with too.

    The Solution Manager connectivity is one area in particular where there is a lack of SCN love. If you’re that way inclined, I think people would like to read about this. 🙂

    (0) 
    1. Henricus Bouten Post author

      Thanks, John.

      I’m from the SAP NetWeaver Technology side, so system administration is my area. SAP Solution Manger is part of it, and I will do more posts in the SolMan area.

      But first SAP HANA SPS09 HA200 course development to update the HA200 from SPS08 to SPS09 and include all the nice Fiori dashboards in the course 🙂

      (0) 

Leave a Reply