MSSQL Monitor
Monitors backups and filling degrees of a Microsoft SQL database
General
| Executable | MSSQL_Monitor.exe |
| Connection method | ODBC |
| Ports |
|
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 |
| 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 | 10 | Past days for which the backup is to be checked |
| Snapshot | (0=no, 1=yes) | 1 | Check also snapshot backups |
Channels
| Channel name | Description | Lookup file |
|---|---|---|
| Successful Backups | Check also snapshot backups (0=no, 1=yes) | |
| <SCHEMA> - % free | Free space for schema <SCHEMA> (percent) | |
| <SCHEMA> - MB free | Free space for schema <SCHEMA> (MegaByte) | |
| <SCHEMA> - Total Size | Available size for schema <SCHEMA> | |
| <SCHEMA> - Log Size | Available log size for schema <SCHEMA> | |
| <SCHEMA> - Log % free | Free log space in schema <SCHEMA> |
Important notes
warning
Please check the channel limits in PRTG if they fit for your alerting.
Changelog
| Version | Changes |
|---|---|
| 2024.10 | Fixed connection error when having a database name containing a dash |
| 2024.07 | Corrected wrong channel values when using specific region settings |
| 2023.03 | Added channels for log size and log space used. |
| 1.4.0.1 | Rebuild for new signature of AddChannel method |
| 1.4.6.0 | Build for installer 1.4.0 |
| 1.3.6.0 | First stable release |