Sybase Monitor
Monitors sessions, status, locks, usage, log backups of all Sybase DB's in one installation
General
| Executable | Sybase Monitor.exe |
| Connection method | ODBC |
| Ports | 4901 |
| Lookup files |
|
Default parameters
| Parameter name | Possible values | Default | Description |
|---|---|---|---|
| Host | <ip> | <hostname> | <fqdn> | 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 | <dbname> | empty | Database name |
| DBPort (optional) | Default: 4901 <port> | empty | Database port |
| DBUsername | <username> | empty | Database user |
| DBPassword | <password> | empty | Password for <DBUsername> |
Sensor-specific parameters
| Parameter name | Possible values | Default | Description |
|---|---|---|---|
| Days | number | 0 - n | 0 (No backup check) | Past days for which the backup is to be checked |
| IncludeForLogModeCheck | NONE | ALL | <dbname1>,<dbname2>,... | NONE | List of databases for which the log mode should be checked. DBName can be used as placeholder to use the DB name given in the profile for the DB connection. |
| SSLEnabled | false | true | false | Defines wether an SSL connection should be used or not. |
| SSLTrustedFile | <filename> | Trusted.txt | File located in folder Sybase_Monitor which holds trusted CA certificates for SSL connections. |
| CheckBackupServer | false | true | false | Defines whether the status of the Sybase backup server should be checked or not. |
Channels
| Channel name | Description | Lookup file |
|---|---|---|
| Session Usage | Number of database sessions | |
DB: <database> - Successful Backup last <Days> days | Number of successful backups in the last <days> days | |
| DB: <database> Usage | Database usage in percent | |
| DB: <database> MB Usage | Database usage in megabyte | |
| DB: <database> Status | Database Status Monitoring- Databases in the status suspect, for load, read only, dbo use only and single user mode will cause a warning state | itesys.sybase_monitor.db_state.ovl |
| DBLog: <database> Usage | Database log area usage in percent | |
| Lock Usage | Number of locks in the Sybase instance | N.A |
| DB: <database> Log Mode | Status Monitoring of "trunc log on chkpt"
| itesys.sybase_monitor.logmodecheck.ovl |
| Backup Server Status | Sybase backup server status monitoring. If the backup server is not running or can’t be reached the sensor will cause an error state |
Important notes
warning
Please check the limits in PRTG if they fit for your alerting.
Troubleshooting
| Symptom | Possible solution |
|---|---|
Could not connect to ASE database: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified | Please install the correct 64-bit ASE ODCB driver on the PRTG server. |
Changelog
| Version | Changes |
|---|---|
| 2023.06 | Added a channel to optionally check the status of the backup server Error handling has been implemented in case of null values in DBSpace check |
| 2023.03 | Added possibility to use SSL connection. |
| 2022.12 | No error occurs anymore in case of NULL values. Added channel and parameter to check "trunc log on chkpt" |
| 2022.05 | Updated the sensor to get more accurate values for Spaceusage channels |
| 2021.12 | Corrected calculation of used space in MB to have more accurate values |
| 1.4.0.4 | Corrected backup check (sp_dump_history changed output on ASE 16 SP03) |
| 1.4.0.2 | Rebuild for new signature of AddChannel method |
| 1.4.0.1 |
|
| 1.4.0.0 | Build for installer 1.4.0 |
| 1.3.6.1 | Removed parameter Days from channel to prevent additional channels on parameter change |
| 1.3.6.0 | First stable release |