[hobbit] MS SQL hobbit monitoring

[Dugan, Darin D [EIT]]

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:dns1407 at yahoo.com] 
Sent: Thursday, July 10, 2008 8:32 AM
To: hobbit at hswn.dk
Subject: Re: [hobbit] MS SQL hobbit monitoring

Why not? What's the problem? 


----- Original Message ----
From: "Roberts, James" <James.Roberts at hants.gov.uk>
To: hobbit at hswn.dk
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:dns1407 at yahoo.com] 
Sent: 09 July 2008 14:36
To: hobbit at hswn.dk
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" <James.Roberts at hants.gov.uk>
To: hobbit at hswn.dk
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