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 |
|
| 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 | 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:
| 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.licensemodecheck.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
| itesys.hanamonitor.replicationstatus.ovl |
| <host> shipping delay | Log Shipping Delay for the named replication host |
Lookup values
Values, states and texts defined in the lookup files of this sensor.
Lookup file: itesys.hanamonitor.lastbackup.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Successful |
1 | OK | Running |
2 | OK | Prepared |
3 | Warning | No backup |
4 | Warning | Undefined |
5 | Error | Failed |
6 | Error | Canceled |
7 | Error | Cancel pending |
Lookup file: itesys.hanamonitor.licensemodecheck.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Unlimited |
1 | Warning | License is about to expire. |
2 | Error | License has expired. |
3 | Error | No license installed. |
Lookup file: itesys.hanamonitor.logmodecheck.ovl
| Value | State | Description |
|---|---|---|
0 | OK | No overwrite and backup |
1 | Warning | Overwrite and non-prod |
2 | Error | Overwrite and prod |
3 | Error | No overwrite and no backup |
Lookup file: itesys.hanamonitor.replicationstatus.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Active |
1 | Error | Error |
2 | Warning | Warning |
3 | OK | No Replication configured |
Important notes
warning
Please check the channel limits in PRTG if they fit for your alerting.
Troubleshooting
| Error Code | Error Message | Possible Solution |
|---|---|---|
[SCN-051-000] | The following parameters has not been provided: <parameters> Please read the sensor documentation for further information! | Specify the listed parameters in the profile or in the sensor-specific parameters. |
[SCN-051-103] | Could not connect to HANA database: <message> | Check the parameters Host, DBPort, DBName, DBUsername and DBPassword and that the database is reachable from the PRTG probe. If the message is ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, please install the 64-bit HDB client incl. ODBC driver on the PRTG probe. |
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 |
|
| 2021.12 | Fixed bug which causes an error when secondary node was not connected and therefore shipping delay was empty |
| 2021.09 |
|
| 2021.03 |
|
| 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 |
|
| 1.3.6.1 | Added threshold values |
| 1.3.6.0 | First stable release |