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