Page 1 of 1

SQL Store Procedures

Posted: Mon Apr 15, 2013 11:33 am
by tavo2k4
Hello,
I am testing Nagios as a proof of concept to some of our customer so they can monitor our application.

Is there a Document on how to set up Nagios to execute SQL Store Procedures and display results in an informative way?

For example, how to monitor the row count of a table, if it reaches a threshold of 1000 it will display a error or warning message.

Thank you,

Gus G.

Re: SQL Store Procedures

Posted: Mon Apr 15, 2013 2:22 pm
by abrist
MSSQL or MYSQL?

Re: SQL Store Procedures

Posted: Mon Apr 15, 2013 3:22 pm
by tavo2k4
Well it is Sybase actually, but I read somewhere that I can use MSSQL when configuring Nagios.

Re: SQL Store Procedures

Posted: Mon Apr 15, 2013 4:36 pm
by abrist
Have you taken a look at the mssql plugin below?
http://exchange.nagios.org/directory/Pl ... ts/details