MSSQL database status change monitoring

[jyoti22]

Hi Team,
In my current engagement, for MsSQL monitoring, customer wanted to monitor database state changes. Can anyone configured this monitoring in their environment? please share the artifacts and plugin details.
Also I wanted to monitor .ldf and .mdf datafile and logfile growth can anyone please help me on this as well.

check_mysql_health do not have these options

Thanks.

[mcapra]

check_mysql_health do not have these options

It is also not a particularly useful plugin for SQL Server in general.

Could you expand on what you mean by "state changes"? By definition, state as it relates to SQL Server can be monitored in the sense of "ONLINE" versus all other states by using the SQL Server Configuration Wizard, specifically the "MSSQL Query" wizard. If the state of the database is anything other than "ONLINE", the plugin should produce a critical as it will not be able to establish a connection. Your query could be something as simple as

Code: Select all

SELECT DB_NAME() AS [Current Database];

if all you wanted to do was make sure that database is in an ONLINE state.

Here's the official documentation for using the SQL Server config wizards:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

[kyang]

Thanks for the help @mcapra!

jyoti22, please let us know if you have any more questions. Otherwise read through what mcapra suggested.