SAP HANA Database Monitoring

Overview

SAP HANA is a latest, in-memory, column-oriented, relational database management system developed and marketed by SAP SE, which can be deployed on-premises or on cloud. It is a combination of hardware and software, which integrates different components, such as SAP HANA Database and SAP System Landscape Transformation (SLT).
This monitor provides monitoring of different stats, such as memory usage by SAP HANA, user connections, long running statements, and so on.

* SAP stands for System Application Product
* HANA stands for High Performance Analytic Appliance

Database Functions

In memory computation

Columnar Database

Data Compression

Massive parallel processing of data

Database Design

In SAP HANA, a disk is attached with RAM (unlike other databases), which enables easy storage and fetching of the data.

SAP HANA Users

Graph NameHANA Users
Data TypeSample
Graph DescriptionDisplay the number of users in database

SAP HANA Schema Memory

Graph NameHANA Schema Memory (MB)
Data TypeSample
Graph DescriptionDisplay the Schema Memory (in MB) of database

SAP HANA Peak Memory

Graph NameHANA Users
Data TypeSample
Graph DescriptionDisplay the Peak Memory (in MB) of database

SAP HANA Resident Memory

Graph NameHANA Resident Memory (GB)HANA Physical Memory (GB)
Data TypeSampleSample
Graph DescriptionDisplay the Resident Memory (in GB) of databaseDisplay the Physical Memory (in GB) of database

SAP HANA Memory Allocation

Graph NameHANA Allocated Memory (MB)
Data TypeSample
Graph DescriptionDisplay the Allocate Memory in MB of database

SAP HANA SavePoints

Graph NameHANA Flushed Pages
Data TypeSample
Graph DescriptionDisplay the Save Points (flushed pages) stats of database

SAP HANA Backup

Graph NameHANA Catalog Size (MB)HANA Oldest Backup Days
Data TypeSampleSample
Graph DescriptionDisplay the catalog size (in MB) of databaseDisplay the oldest backup days of database

SAP HANA Memory Component

Graph NameHANA Memory Component
Data TypeSample
Graph DescriptionDisplay the component memory (in MB) of database

SAP HANA Network

Graph NameHANA Tcp Segments Received (kbps)HANA Tcp Bad Segments Received (kbps)HANA Tcp Segments Retransmitted(kbps)
Data TypeRateRateRate
Graph DescriptionDisplay the TcpSegmentsReceived (in kbps) per secondĀ  stats of databaseDisplay the TcpBadSegmentsReceived (in kbps) stats of databaseDisplay the TcpSegmentsRetransmitted (in kbps) stats of database

SAP HANA Active Connection

Graph NameHANA Active Connection
Data TypeSample
Graph DescriptionDisplay number of active connections of database

SAP HANA Disk Usage

Graph NameHANA Used Disk(MB)HANA Used Disk(pct)HANA Total Disk(MB)
Data TypeSampleSampleSample
Graph DescriptionDisplay the used disk (in MB) stats of databaseDisplay the used disk (in Pct) stats of databaseDisplay the total disk (in MB) stats of database