Perhaps this will be helpful. I finally got around to giving this script a try today and made three changes:
1. I had to run "winmgmt /resyncperf" to get the relevant perf counters registered with WMI.
2. Instead of adding an additional registry key for the output I changed the line to read BBWin's tmppath key:
extPath = ws.RegRead("HKLM\SOFTWARE\BBWin\tmppath")
3. I put in explicit casts on iObjectValue, iWarnValue and iAlarmValue in CheckValue and CheckReverseValue. Prior to doing this some of my counters went red even though they were well below (or above) the warn threshold. Digging for a while I found the comparisons were failing until I used "Int(iObjectValue)", etc.
With some additional graphing I think this would be a great addition to the shire. I see an older version is posted at deadcat.
Cheers.
From: DNS [mailto:user-08e747311acb@xymon.invalid]
Sent: Thursday, July 10, 2008 8:32 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] MS SQL hobbit monitoring
Why not? What's the problem?
----- Original Message ----
From: "Roberts, James" <user-d7df29bbad83@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
Sent: Thursday, July 10, 2008 2:48:51 PM
Subject: RE: [hobbit] MS SQL hobbit monitoring
this didnt work for me...has anyone else got any ideas?
From: DNS [mailto:user-08e747311acb@xymon.invalid]
Sent: 09 July 2008 14:36
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] MS SQL hobbit monitoring
Yep, with the following vbs-script...
====Begin======
<long vbs snipped>
===End====
In the registry of the Windows host you have to add:
[HKEY_LOCAL_MACHINE\SOFTWARE\BBWin\Output]
@="C:\\Program Files\\BBWin\\tmp"
----- Original Message ----
From: "Roberts, James" <user-d7df29bbad83@xymon.invalid>
To: user-ae9b8668bcde@xymon.invalid
Sent: Wednesday, July 9, 2008 12:26:12 PM
Subject: [hobbit] MS SQL hobbit monitoring
Has anyone had any success from using hobbit to monitor ms sql server?
Thanks