Page 1 of 1

combining values in SQL database monitoring

Posted: Mon Nov 30, 2015 9:16 am
by dlukinski
Hello Nagios support

How could we proceed about combining values, like calculating total number of databases and their size per instance when monitoring SQL?

Thanks

Re: combining values in SQL database monitoring

Posted: Mon Nov 30, 2015 10:38 am
by rkennedy
Are you trying to use a certain plugin? This should be possible, but you'd have to write a bit of custom code to organize your data as needed unless there is something available at our exchange already.

Did you look at the exchange yet? https://exchange.nagios.org/index.php?o ... word=mysql

Re: combining values in SQL database monitoring

Posted: Mon Nov 30, 2015 12:07 pm
by dlukinski
rkennedy wrote:Are you trying to use a certain plugin? This should be possible, but you'd have to write a bit of custom code to organize your data as needed unless there is something available at our exchange already.

Did you look at the exchange yet? https://exchange.nagios.org/index.php?o ... word=mysql
Hi

Not that I think.

For Microsoft SQL server we need to calculate number of databases and their sizes (what you posted was for MySQL)

Re: combining values in SQL database monitoring

Posted: Mon Nov 30, 2015 4:09 pm
by rkennedy
Ah, here's the link for MSSQL.
https://exchange.nagios.org/index.php?o ... word=mssql

Do any of those work for you?

Re: combining values in SQL database monitoring

Posted: Wed Jul 20, 2016 1:40 pm
by dlukinski
rkennedy wrote:Ah, here's the link for MSSQL.
https://exchange.nagios.org/index.php?o ... word=mssql

Do any of those work for you?
Please close this case

Thank you

Re: combining values in SQL database monitoring

Posted: Wed Jul 20, 2016 1:44 pm
by mcapra
Closing per your request