Introduction

In the upcoming weeks we will be posting new videos to the SAP HANA Academy to show new features and functionality introduced with SAP HANA Support Package Stack (SPS) 7. To get the best overview of what’s new in SAP HANA SPS 7, see Ingo Brenckmann’s blog on the SAP HANA community site. The delta presentation comparing changes since SPS 6 by SAP HANA Product Management can be found on the SAP HANA web site.

The topic of this post is monitoring and complements a number of tutorial videos posted to the SAP HANA Academy site and on YouTube:


Other blogs on the What’s New topic

What’s New with SPS 7?

A “dazzling highlight“,  in the words of Lars Breddemann are the new graphical editors: Memory Overview (shown below), Resource Allocation and Memory Allocation Statistics. The editors also caught the attention of John Appleby in his blog on monitoring.

/wp-content/uploads/2014/01/memory_354895.png

SAP HANA Studio – Memory Overview

Although you can add as many as 18 memory-related statistics to a table viewer in HANA studio, this is not the most intuitive as you can see below.

/wp-content/uploads/2014/01/services_354986.png

Memory statistics in SAP HANA Studio, Administration Console, Landscape, Services

To get any graphical display of resource usage over time, before SPS 7, you could use the administration console, performance – load tab. This viewer has not changed much (if any) from the BWA admin tool, which is still included, slightly modified, with SAP HANA (command HDB admin). You need good eyesight, good glasses or a big screen to view clearly as color and line style cannot be modified.

/wp-content/uploads/2014/01/admin_354987.png /wp-content/uploads/2014/01/load_354988.png

Load graph from the SAP HANA database administration tool and SAP HANA studio.

Hence, the new web-based graphical editors Memory Overview, Resource Allocation and Memory Allocation Statistics are a welcome enhancement as they provide a much clearer and visually attractive display of monitoring data. They all use the SAP HANA XS built-in application server. You can view the new editors in action in this overview video on what’s new with monitoring for SAP HANA SPS 7.

Monitoring SAP HANA: What’s New in SPS 7

New Statistics Server

SPS 7 also introduces a new implementation for the statistics server. This statistics server is the component of the SAP HANA database that continuously collects data about system status, performance, and resource usage. It also issues alerts in the case of problems. As of SPS 7, it is possible to switch to a new mechanism whereby data collection and alerting are implemented through the execution of SQLScript procedures. This has two advantages.

  1. Improved performance – reduction of disk I/O and memory usage by replacing the OS process with internal procedure calls
  2. Increased configuration flexibility – statisticsserver.ini properties file is replaced by tables in the _SYS_STATISTICS schema, which allows for adhoc enable/disable and scheduling of collection

The following video discussed the new statistics server and how to enable it, as it is not active by default.

Monitoring SAP HANA: New Statistics Server

Performance Analysis Guide

New in the documentation set of SAP HANA SPS 7 is the Performance Analysis Guide, which focusses on performance analysis and monitoring. This guide describes what you can do to identify and resolve performance issues and how to enhance the performance of the SAP HANA database in general. Regarding monitoring, the guide describes the different tabs in the SAP HANA studio administration console under performance, like threads, sessions, blocked transactions, job progress and load monitoring.

Other documentation on monitoring can be found in the Administration Guide and the Technical Operations Manual. The video below provides a short overview.

Monitoring SAP HANA: Documentation

Monitoring Tools Overview

In case you are new to the subject of SAP HANA monitoring – or are preparing yourself for the SAP Certified Technology Associate exam – you may find this overview video helpful about the different tools you can use to monitor SAP HANA.

Monitoring SAP HANA: Tools Overview

System Views

More advanced is the topic of system views. SAP HANA contains hundreds of monitoring views in the _SYS._STATISTICS schema that you can use to write your own monitoring scripts in SQL. Getting started on this topic can be a bit of a challenge. However, there is a shortcut you could take. When you navigate through SAP HANA studio, going from tab to tab, enabling or disabling settings for the HANA database, what is actually being sent over the line is just plain SQL. In the video below, we will show you how you can capture the statements using SQL trace and how they can be used for custom monitoring scripts.

The resulting SQL script is attached to this SAP HANA site document.

Monitoring SAP HANA: System Views

Monitoring Role and Security

Both the administration and the installation guide clearly document not to use the SYSTEM user in production system.

/wp-content/uploads/2014/01/caution_355015.png

However, less clearly documented is how to setup a monitoring role that you can use to grant to database administrators. What about the built-in MONITORING role, you might say? That’s a good start, it is true. It grants GRANT CATALOG READ, so you can use the administration console perspective in SAP HANA studio, and also grants SELECT on the _SYS_STATISTICS schema, so you can view data in System Monitor and the different tabs of the Administration editor. However, with only the MONITORING role granted, you will get an error when trying to open the new web-based graphical editors. What privileges are needed to handle a Disk Full Alert? Restart a service? Cleanup traces? This and more is explained in the video below:

Monitoring SAP HANA: Monitoring Role

Monitoring Checklist

The SAP HANA Administration Guide includes a helpful monitoring checklist. In the last video on monitoring SAP HANA, we show you how to check system availability, how to handle alerts, monitor memory, cpu and disk resource usage and much more.

As with the video on monitoring tools above, you might find this video tutorial helpful when you are preparing for the SAP Certified Technology Associate exam. Details on this certification you can find in the SAP Education and Certification Shop.

Monitoring SAP HANA: Checklist

To be continued…

You can view more free online videos and hands-on use cases to help you answer the what, how and why questions about SAP HANA and Analytics on the SAP HANA Academy at academy.saphana.com or follow us on Twitter @saphanaacademy.


To report this post you need to login first.

10 Comments

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

  1. Denys van Kempen Post author

    FYI


    The SPS 7 release notes contain the following information:

    Statistics Server (Changed)

    As of SPS 07, it is possible to switch to a new mechanism whereby data collection and alerting are implemented through the execution of SQLScript procedures (…)

    For more information about how to migrate to the new mechanism after an upgrade, see SAP Note 1917938.

    This note is today available only in German: 1917938 – Migration des Statistics Server mit dem Upgrade auf SPS 7 ; this note mentions that when using either DBA Cockpit or Solution Manager, you need to consider note 1925684 – ABAP-Anpassungen für SAP HANA SPS 7 ; and this note then mentions that support is provided for new statistics server in SAP BASIS SP11 or, alternatively, by implementing the corrections included in the note.

    Note 1925684 is scheduled for release with HANA revision 71, planned end of January, while SAP BASIS SP 11 is scheduled for release early March.

    (0) 
    1. Denys van Kempen Post author

      Hi,

      Did you grant the required privileges?

      However, with only the MONITORING role granted, you will get an error when trying to open the new web-based graphical editors. What privileges are needed to handle a Disk Full Alert? Restart a service? Cleanup traces? This and more is explained in the video below:

      Monitoring SAP HANA: Monitoring Role

      (0) 
  2. bl vijaykumar

    Hi Denys,

    when I try to open dashboard in HANA it is throwing me 404 page not found.. in configuration->xsengine.ini->develop  and developer_mode value TRUE..

    i feel like i have to do bit more unable to figure out where problem lies…

    please help me with any notes or guidence…

    Thanks

    vijay

    (0) 
    1. Denys van Kempen Post author

      Hi,

      404 is a typical return by the XS server for not authorized… ( I know, but this is part of secure computing, the server pretending it does not know )

      Have you checked the authorizations for your user ( don’t use SYSTEM )?

      (0) 

Leave a Reply