HANA Monitor (deprecated)

Deprecated

This sensor is deprecated. Please use SAP HANA Monitor and SAP System Monitor instead.

Monitors license, services, replication status, backups etc. for a SAP HANA database.

General

Executable	HANA_Monitor.exe
Connection method	ODBC
Ports	5$$13 5$$14 3$$15 ($$ = instance number)
Lookup files	itesys.hanamonitor.lastbackup.ovl itesys.hanamonitor.licensecheck.ovl itesys.hanamonitor.logmodecheck.ovl itesys.hanamonitor.replicationstatus.ovl

Default parameters

Parameter name	Possible values	Default	Description
Host	<ip> | <hostname>	empty	Hostname or IP of the target system. If you use a virtual hostname on your SAP servers, please use also the virtual host to connect.
DBName	string	empty	Name of the database
DBInstance	number (2) | 00 - 99	empty	Instance number of the database.
DBPort	number (5) | 0 - 65535	empty	Port to establish ODBC connection.
DBUsername	string	empty	Database user
DBPassword	string	empty	Password of the database user

Sensor-specific parameters

Parameter name	Possible values	Default	Description
Days	number | 0 - n	5	Past days for which the backup is to be checked
CheckServices	true | false	true	Defines whether the services check via sapstartsrv should be executed or not.

Channels

Channel name	Description	Lookup file
Successful Backups	Number of successful backups in the last <Days> days
Successful Log Backups	Number of successful log backups in the last <Days> days
Successful Incremental Backups	Number of successful incremental backups in the last <Days> days
Successful Differential Backups	Number of successful differential backups in the last <Days> days
Last Backup	Displays the status of the last data backup. Range: OK: successful OK: running OK: prepared Warning: no backup Warning: undefined status Error: failed Error: canceled Error: cancel pending	itesys.hanamonitor.lastbackup.ovl
Last Log Backup	Displays the status of the last log backup. Range: OK: successful OK: running OK: prepared Warning: no backup Warning: undefined status Error: failed Error: canceled Error: cancel pending	itesys.hanamonitor.lastbackup.ovl
Log Mode Check	Status of log mode and automatic log backups with differentiation of production and non-production systems OK = automatic log backup and log mode normal is activated Warning = log mode overwrite of non production systems is activated Error = log mode overwrite of production systems is set Error = no automatic log backup and log mode normal is set	itesys.hanamonitor.logmodecheck.ovl
License Status	Current license status	itesys.hanamonitor.licensecheck.ovl
License Days until expiration	Days remaining until license expiration, 9999 = unlimited
Memory Usage	Current memory consumption
Memory Usage %	Current memory consumption in percentage
Column Store Memory Usage	Memory used by Column Store Tables
HDB Services Running	Number of running hdb* services with "GREEN" status
Free Log Segments	Number of free log segments
Used Log Segments	Number of used log segments
Connections	Number of open connections
Sessions	Number of active sessions
Threads	Number of active threads
Locks	Number of locks
Jobs Running	Number of running jobs
Replication status	Status of the replication if configured Active Warning Error Replication not configured	itesys.hanamonitor.replicationstatus.ovl
<host> shipping delay	Log Shipping Delay for the named replication host	itesys.hanamonitor.replicationstatus.ovl

Important notes

warning

Please check the channel limits in PRTG if they fit for your alerting.

Troubleshooting

Symptom	Possible solution
Receiving error message Could not connect to HANA database: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified	Please install 64-bit HDB client incl. ODBC driver on the PRTG server

Changelog

Version	Changes
2024.07	Deprecated and replaced by SAP HANA Monitor and SAP System Monitor
2023.03	Value of "Last Log Backup" Channel has been corrected.
2022.08	Added channels for count of incremental and differential backups. The use of the special characters ; in the database password of the monitoring user is supported now.
2021.12	Fixed bug which causes an error when secondary node was not connected and therefore shipping delay was empty
2021.09	Introduced parameter "CheckServices" to make the sensor useable even if no OS user is available Optimized license check to avoid error if no license is installed (e.g. for HANA Cockpit installation)
2021.03	The calculation of the peak memory of the last 12 months is sometimes wrong. That depends on the HANA patch version which is used. Now the total consumption of the peak HANA memory is displayed correctly. Added channel "Log Mode Check"
2020.09	Adapted the order of the lookup values (0-7) of the channels "Last Backup" and "Last Log Backup"”" for a better setup of notification thresholds
2020.06	Added new "last Backup" and "Last Log Backup" channels
1.4.0.1	Rebuild for new signature of AddChannel method
1.4.0.0	Build for installer 1.4.0
1.3.7.0	Added channel to represent replication status Added lookup file itesys.hanamonitor.replicationstatus.ovl
1.3.6.1	Added threshold values
1.3.6.0	First stable release