[hobbit] MS SQL Monitoring

[Buchan Milne]

On Tuesday 17 February 2009 07:55:07 Neil Franken wrote:
> Hi Guys
>
>
>
> Maybe you can help. I would like to monitor my  MS SQL installations
> with more detail.  They give more trouble than the MySQL installs (go
> figure). Anyway went to dead cat download the  bb-sqlserver.vbs script.
> I made changes to the BBWin.cfg script to run this script. The entry
> looks as follows <load value="cscript bb-sqlserver.vbs" timer="1m" />.
> The problem is when I run this script but it throws some weird
> wmiprvse.exe unkown software exception. Anyway this script does not run.
> I had a look at the mail archives and I found a thread where they
> mentioned doing some modifications to the script to make it work. I did
> follow these steps.
>
>
>
> Anyway..... has anyone had success in monitoring more SQL specific data.

Well, AFAIK, dbcheck.pl from http://sourceforge.net/projects/hobbit-perl-cl/ 
should be able to monitor MS SQL as well (remotely, from a Unix host e.g. your 
Hobbit/Xymon server).

I haven't used it with MS SQL yet (don't have database accounts to use on the 
MSSQL boxes in our environment yet), but we use it for MySQL and Oracle, and 
apparently it supports Oracle, Informix, SQL Server, MySQL and DB2.

Regards,
Buchan