Online Training
Q4 2024

Nov 19 to Dec 10

11.00 AM EST: USA, UK, Canada, Mexico and Europe

06.00 AM GMT: MiddleEast, Asia and Australia

Register Now

SAP HANA Monitoring

Monitor the availability and performance of your SAP HANA database with Site24x7's ready-to-install SAP HANA monitoring plugin integration. Track key metrics and gain insights into the health of your SAP HANA database to stay ahead of issues before they start affecting end users.

Start 30-day free trial Try now, sign up in 30 seconds
SAP HANA Monitoring

What is SAP HANA?

SAP HANA (which stands for High-performance ANalytic Appliance) is a column-oriented database that stores data in its memory instead of on a disk. This unique architecture enables SAP HANA to process and query massive amounts of data with near-zero latency, which is significantly faster than other database management systems and allows for advanced, real-time analytics.

Monitor the performance of your SAP HANA database

Track the health of your SAP HANA database servers and stay ahead of issues and bottlenecks. View critical SAP HANA metrics on a single dashboard and troubleshoot issues effectively with instant alerts.

Get insights on critical SAP HANA performance metrics

Monitor key performance metrics, including CPU, memory, connections, and expensive statements, to ensure an optimal user experience.

Stay updated with instant alerts

Get instant notifications every time values cross predefined threshold limits so you can swiftly implement preventative or recovery measures.

Remediate incidents with event-driven IT automation

Set up automated workflows to take corrective action in SAP HANA when breaches of predefined thresholds occur.

Create custom dashboards

Assemble data from different parts of your infrastructure with drag-and-drop widgets and build personalized dashboard views.

Start 30-day free trial Try now, sign up in 30 seconds

Get started with Site24x7's SAP HANA monitoring tool

Get Started

  • Supported Platforms:
  • Python Version:
    2.7 & above
  • Linux Agent Version:
    15.0.0 & above

Performance Metrics

You can track the following metrics with the SAP HANA monitoring plugin:

Name Description
Active Threads The number of active threads
Active Transactions The number of active transactions
Backup Catalogs The total number of backup catalogs
CPU Usage The CPU used by all processes as a percentage
Data Disk Free Size The volume of the free size of the data disk
Disk Free Size The disk free size in gigabytes
Free Physical Memory The free physical memory on the host in gigabytes
Idle Connections The number of idle connections
Inactive Transactions The number of inactive transactions
Index Server Memory Pool Heap Used Size The amount of pool heap memory that is in use on the index server
Index Server Memory Pool Used Size The amount of memory in use from the memory pool of the index server
Index Server Memory Pool Shared Used Size The amount of shared memory that is in use from the memory pool of the index server
Log Disk Free Size The volume of the free size of the log disk
Name Server Memory Pool Heap Used Size The amount of memory in use from the memory pool of the name server
Name Server Memory Pool Used Size The amount of memory in use from the memory pool of the name server
Name Server Memory Pool Shared Used Size The amount of shared memory that is in use from the memory pool of the name server
Plan Cache Hit Ratio The SQL plan cache hit ratio
Plan Cache Size TThe total size of the SQL plan cache in gigabytes
Queuing Connections The total number of connections currently queued
Replication Errors The number of replications in error
Replication Syncing The number of syncing replications
Running Connections The total number of statements getting executed
Start Time of Services The start time of services in seconds
Total Active Statements The total number of active statements
Total Alerts The total number of alerts
Total CPU Idle Time The total CPU idle time in minutes
Total Caches The total number of caches
Total Column Unloads The total number of column unloads
Total Delta Merge Errors The total number of table delta merge statistics
Total Expensive Statements The total number of expensive statements
Total Network I/O Operations The total number of network I/O operations
Used Physical Memory The used physical memory on the host in gigabytes

Setup

Prerequisites

Ensure you meet the following requirements before installing the plugin:

  • You need a Site24x7 account. If you don't have one, sign up here for free.
  • Download and install the Site24x7 server monitoring agent (Linux | Windows) on the server where you intend to run the plugin.
  • Ensure that the hdbcli module is installed.
    If it is not installed, execute the following command to install it.
    pip install hdbcli
  • Ensure that public and monitoring role access has been provided to the SAP HANA user profile that will be added to the plugin configuration file (sap_hana_database.cfg).
    GRANT ROLE PUBLIC to user
    GRANT ROLE MONITORING to user

Installation

  • Create a folder named sap_hana_database.
  • Download the sap_hana_database.py file and the sap_hana_database.cfg file from our Github repository and place them in the sap_hana_database folder.
    wget https://raw.githubusercontent.com/site24x7/plugins/master/sap_hana_database/sap_hana_database.py
    wget https://raw.githubusercontent.com/site24x7/plugins/master/sap_hana_database/sap_hana_database.cfg
  • Add the following configuration in sap_hana_database.cfg file:
    [sap_hana_database]
    host = <hostname>
    port = <port>
    username = <username>
    password = <password>
  • Follow the steps in this article to learn how to run the python script on a Windows server. You don't need to do this for Linux.
  • Move the sap_hana_database folder to the Site24x7 server monitoring plugin directory.
    For Linux: /opt/site24x7/monagent/plugins/
    For Windows: C:\Program Files (x86)\Site24x7\WinAgent\monitoring\plugins\
  • To verify that the plugin is working, execute the command below with appropriate arguments to check for a valid JSON output:
    python sap_hana_database.py --host= --port= -- username= --password=
  • The plugin integrates with Site24x7 AppLogs so that you can analyze your SAP HANA database logs and identify the root cause of issues. To enable SAP HANA logs, make configuration changes by adding logs_enabled, log_type_name, and log_file_path in the sap_hana_database.cfg file as shown below.
    Note: In the command below, update the log_file_path with the appropriate location where the server contains the SAP HANA logs. Also, fill in the system ID, instance number, and hostname with the applicable details.
    [sap_hana_database]
    host=<hostname>
    port=<port>
    username=<username>
    password=<password>
    logs_enabled=True
    log_type_name="saphana_log"
    log_file_path="/usr/sap/<SID>/HDB<Instance number>/<hostname>/trace/*.log"

The agent will automatically execute the plugin within five minutes and send performance data to the Site24x7 data center.

To view performance charts and set thresholds for the various performance metrics:

  • Log in to Site24x7.
  • Navigate to Server > Plugin Integrations
  • Click the required monitor.

Plugin Contribution

Feel free to contribute to our existing plugin and come up with suggestions or feedback on our Community.

  • Supported Platforms:
  • Python Version: 2.7 & above
  • Linux Agent Version:15.0.0 & above

Over 13,000 customers trust Site24x7

Brand logos of our various customers

Check out our 100+ plugin integrations or build your own

Choose from our list of more than 100 ready-to-use plugins and monitor your full stack of applications across web servers, databases, load balancers, and more.

Apache Monitoring

Apache
HAProxy Monitoring

HAProxy
Kafka Monitoring

Kafka
ActiveMQ Monitoring

ActiveMQ
Wordpress Monitoring

Wordpress
Tomcat Monitoring

Apache Tomcat
Elasticsearch Monitoring

Elasticsearch
Dell iDRAC Monitoring

Dell iDRAC
NGINX Monitoring

NGINX and NGINX Plus
Memcached Monitoring

Memcached
See all plugin integrations
Start 30-day free trial Try now, sign up in 30 seconds