I am trying to setup Nagios monitoring for SQL server, I was wondering if anyone can guide me through the process from the very start to finish, what needs doing etc. Basically, what I am looking to do is get Nagios to call scripts on Linux which in turn calls a stored procedure on SQL server, this SQL server stored procedure will return a value single column, say 1 or 0. If its 0 alert that something is wrong, if its 1 alert that all is fine.
How can I do this and what needs installing ?
Thanks in advance.