search

lausser / check_mssql_health

Wenn du dich für Plugins (oder OMD oder allgemein Monitoring) interessierst oder von deiner Installation erzählen willst...die Tradition der deutschsprachigen Monitoring-Workshops wird wiederbelebt: https://discord.gg/jDfPZ63FcJ A plugin, which checks various parameters of Microsoft SQL database servers.
http://labs.consol.de/nagios/check_mssql_health
GNU General Public License v2.0
38 stars 27 forks source link

Database offline/deleted but Check status OK #47

Open Lprod opened 2 years ago

Lprod commented 2 years ago

We are currently running a remote MSSQL monitoring with the check (check_mssql_health). Our database team noticed that this check does not notice when a database is offline or deleted. Although the check delivers a different output, it remains in the OK status and therefore does not send any notifications. Output if everything is ok: OK - Database is online and accepting connections

Output if database is offline / deleted: OK Is there a fix for this, if necessary, so that such cases are also recognized in the future and an alarm is generated?

lausser commented 2 years ago

Please add "-vvvvvvvvvvvvvvvvvv" when you run the plugin, once when everything is fine, once when the database is offline/deleted and then post the resulting output here or mail it to gerhard.lausser@consol.de

Tenrin1993 commented 2 years ago

I just reverse engeneered our problem. The real case is: We use the --name flag to specify a single databases with the "database-online" mode. If the specified database gets deleted the output is just a blank "ok".

kallekutta commented 8 months ago

I have the same problem with the database-backup-age mode. It's very easy to replicate, just run this command towards a real server with real credentials and type a name of a database that doesn't exist.

check_mssql_health --server asd --username asd --password asd --mode database-backup-age --name asd --warning 25 --commit