[Xymon] Monitor the Microsoft SQL with Xymon

[Jeremy Laidman]

Pradeep

There are two ways to do the monitoring.  One way is to run a script on the
MS-SQL server that reports back to the Xymon server.  This can be achieved
by one of the VBS scripts on the Xymonton Plugins page:
https://wiki.xymonton.org/doku.php/monitors

The other way is to have the Xymon server connect to the MS-SQL server
using a network-based SQL connection.  For this, have a look at this page:
http://sourceforge.net/projects/hobbit-perl-cl/, and this one:
http://heinelt.info/index.php?option=com_remository&Itemid=24&func=fileinfo&id=13
.

You could probably do both.  I've not tested any of these, and I have no
idea how well, or even if, they work.

If all you want to do is check that TCP/1433 is open, then you can do this
with a network check.  As there are no network checks defined for MS-SQL,
you can create one, by adding the following to protocols.cnf:

[mssql]
      port 1433

Then, in hosts.cfg, add an "mssql" tag into the list of tags, like so:

192.168.1.10 mssqlserver.example.com # testip dialup mssql

This should create an "mssql" column with a red or green dot depending on
whether Xymon can connect on TCP port 1433.

Cheers
Jeremy


On 29 July 2015 at 22:05, Pradeep Badiger <pbadiger at enstage.com> wrote:

> Hi Team,
>
>   Can you please help me out to monitor the Microsoft SQL with details
> need your guidelines for configuring XYMON.
>
>
>
> Thanks & Regards,
> Pradeep B
>
> *Sr.System Admin-Linux*
> Information Technology Department
> enStage
> …………………………………………………………………………………………….
> Cell: +91 9845719456; Desk: +91 80 4342 8197      |
> http://www.enstage.com
>
> This message contains confidential information and is intended only for the individual named or entity to whom they are addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.
>
>
> _______________________________________________
> Xymon mailing list
> Xymon at xymon.com
> http://lists.xymon.com/mailman/listinfo/xymon
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20150730/09f97716/attachment.html>