MS SQL Monitoring
list Neil Franken
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
list Dns
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 <user-1689acfc5a3b@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
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
list Neil Franken
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:user-08e747311acb@xymon.invalid]
Sent: 18 February 2009 05:07 PM
To: user-ae9b8668bcde@xymon.invalid
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 <user-1689acfc5a3b@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
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
list 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