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.saphanamonitor.lastbackup.ovl |
| Last Log Backup | Displays the status of the last log backup. Range:
| itesys.saphanamonitor.lastbackup.ovl |
| Log Mode Check | Status of log mode and automatic log backups with differentiation of production and non-production systems
| itesys.saphanamonitor.logmode.ovl |
| License Status | Current license status | itesys.saphanamonitor.licensestatus.ovl |
| License Days until expiration | Days remaining until license expiration, 9999 = unlimited | |
| Replication status | Status of the replication if configured
| itesys.saphanamonitor.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 |
Lookup values
Values, states and texts defined in the lookup files of this sensor.
Lookup file: itesys.saphanamonitor.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.saphanamonitor.licensestatus.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.saphanamonitor.logmode.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.saphanamonitor.replicationstatus.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Active |
1 | Error | Error |
2 | Warning | Warning |
3 | OK | No Replication configured |
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
| Error Code | Error Message | Possible Solution |
|---|---|---|
[SCN-100-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-100-051] | Value for parameter 'Days' is not a correct integer value. Please read the sensor documentation for further information. | Specify a positive integer in the parameter Days. |
[SCN-100-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. |
[SCN-100-300] | Error during license check: <message> | The license information could not be read. Check that the database user has permission to read M_LICENSE. |
Changelog
| Version | Changes |
|---|---|
| 2024.10 |
|
| 2024.07 | First stable release as a replacement for HANA Monitor |