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.
Regards
Neil
Hi Neil,
A while ago i had post message how to do this... search for "MS SQL hobbit monitoring" in Mail archive...
Regards,
DNS
From: Neil Franken <nfranken at theunlimitedworld.co.za> To: hobbit at hswn.dk Sent: Tuesday, February 17, 2009 6:55:07 AM Subject: [hobbit] MS SQL Monitoring
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. Regards Neil
Hi
I actually did read the mail and got part of the script working. However I still keep on getting unkown exception errors. However I have managed to simulate the script with a .Net console application. Here is the juicy bit I wrote the .Net script in Mono…. So when I am finished testing I publish the source code for this application so other people can use it if they want.
Regards
Neil
From: DNS [mailto:dns1407 at yahoo.com] Sent: 18 February 2009 05:07 PM To: hobbit at hswn.dk Subject: Re: [hobbit] MS SQL Monitoring
Hi Neil,
A while ago i had post message how to do this... search for "MS SQL hobbit monitoring" in Mail archive...
Regards,
DNS
From: Neil Franken <nfranken at theunlimitedworld.co.za> To: hobbit at hswn.dk Sent: Tuesday, February 17, 2009 6:55:07 AM Subject: [hobbit] MS SQL Monitoring
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.
Regards
Neil
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
participants (3)
-
bgmilne@staff.telkomsa.net
-
dns1407@yahoo.com
-
nfranken@theunlimitedworld.co.za