SAP HANA Monitor
info
This sensor replaces the deprecated HANA Monitor.
Monitors alerts, backups, replication status, license etc. for a SAP HANA database.
General
| Executable | SAP_HANA_Monitor.exe |
| Connection method | ODBC |
| Ports |
|
| Lookup files |
|
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 (optional) | number | 0 - n | 5 | Past days for which the backup is to be checked |
| EnableAdditionalChannels | true | false | true | Allows to enable some additional channels. Please note that this will increase the execution time of the sensor. |
| IgnoreAlerts | <alert_name1>,<alert_name2>,<alert_name3>,… | Log mode OVERWRITE (because log mode is checked separately) | List of alert names which are to be ignored. |
| SSLEnabled | true | false | false | Defines wether the connection should be encrypted or not. If enabled, make sure that the server certificate or it's issuer was imported into the correct Windows trust store. |
Channels
| Channel name | Description | Lookup file |
|---|---|---|
| Alerts High | Number of high priority alerts | |
| Alerts Medium | Number of medium priority alerts | |
| Successful Complete 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:
| itesys.hanamonitor.lastbackup.ovl |
| Last Log Backup | Displays the status of the last log backup. Range:
| itesys.hanamonitor.lastbackup.ovl |
| Log Mode Check | Status of log mode and automatic log backups with differentiation of production and non-production systems
| itesys.hanamonitor.logmodecheck.ovl |
| License Status | Current license status | itesys.hanamonitor.licensecheck.ovl |
| License Days until expiration | Days remaining until license expiration, 9999 = unlimited | |
| Replication status | Status of the replication if configured
| itesys.hanamonitor.replicationstatus.ovl |
| <host> shipping delay | Log Shipping Delay for the named replication host | |
| Memory Usage % | Current memory consumption in percentage | |
| Memory Usage (optional) | Current memory consumption | |
| Column Store Memory Usage (optional) | Memory used by Column Store Tables | |
| Free Log Segments (optional) | Number of free log segments | |
| Used Log Segments (optional) | Number of used log segments | |
| Connections (optional) | Number of open connections | |
| Sessions (optional) | Number of active sessions | |
| Threads (optional) | Number of active threads | |
| Locks (optional) | Number of locks | |
| Jobs Running (optional) | Number of running jobs |
Important notes
info
This sensor replaces the deprecated HANA Monitor. Since the old sensor also checked the running services, please use the SAP System Monitor in addition to ensure a sufficient monitoring.
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.10 |
|
| 2024.07 | First stable release as a replacement for HANA Monitor |