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