[hobbit] Booking new scripts into Xymon

[Neil Franken]

Interesting response from M$ about WMI and SQL2008

Microsoft was supporting monitoring using WMI till SQL 2005. So
OpManager should be able to fetch information from some WMI classes. But
from SQL 2008 these WMI classes are deprecated and Powershell should be
used to fetch the same kind of information. See this link
http://forums.manageengine.com/topic/no-database-in-sql-2008-express-ins
tance

Seems like powershell is being pushed as the new technology. I went to
the MS Tech Ed 2009 in Durban south Africa and I remember one of the SQL
sessions they showed powershell and how you can use a pipe to string
commands together. The presenter was going on about the power of the
pipe and I thought to myself he must have never touched *nix before
because this aint new.


-----Original Message-----
From: Neil Franken [mailto:nfranken at theunlimitedworld.co.za] 
Sent: 21 June 2010 12:10 PM
To: hobbit at hswn.dk
Subject: RE: [hobbit] Booking new scripts into Xymon

I was just testing that myself. Will merge this into the main file and
release a update during lunch.



-----Original Message-----
From: Walter van Loon [mailto:hobbit at general-failure.com] 
Sent: 21 June 2010 12:06 PM
To: hobbit at hswn.dk
Subject: RE: [hobbit] Booking new scripts into Xymon

One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServer
BufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Bu
ffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLSe
rverBufferManager","@","Buffercachehitratio"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

For our SQL 2008 servers this seems to work fine.

Thanks again for sharing your work; looking forward to your asp.net
monitor.

Walter.


> Yes, I'm sorry about that.
>
> It looks like a WMI issue since "select * from
> sys.dm_os_performance_counters" does show 'normal' values that result
in
> 100% (which is in line with what perfmon on this server shows). It
looks
> as if WMI returns completely different counters/values, very strange.
>
> Walter.
>
>> Hi Walter
>>
>> For the benefits of the other users on the list I will use english. I
>> have not yet tested with 2008. I will let you know what I find when I
>> get the chance.
>>
>> Regards
>> Neil
>>
>> -----Original Message-----
>> From: Walter van Loon [mailto:hobbit at general-failure.com]
>> Sent: 21 June 2010 10:01 AM
>> To: hobbit at hswn.dk
>> Subject: RE: [hobbit] Booking new scripts into Xymon
>>
>> Hi Neil,
>>
>> De DBA's hier zijn blij met deze monitor, bedankt!
>>
>> Als ik het goed begrijp berekent het script de BufferCacheHitRatio
als
>> (value / baseline*100)
>>
>> Met sql server 2008 lijken die counters 'anders' zijn, de baseline is
>> een
>> 9-digit getal en de huidige waarde is een 4-digit getal, het
resultaat
>> is
>> dan altijd een veel te groot getal.
>>
>> Heb jij een idee wat dit is of heb je zelf nog niet getest met sql
2008?
>>
>> Walter.
>>
>>> Hi Guys/Gals
>>>
>>> I think I got it right. I have uploaded the Microsoft SQL Server
>>> Performance script to the repository. I have included graph
>> definitions
>>> and all sorts of goodies. Hope it helps.
>>>
>>>
>>> Regards
>>> Neil
>>>
>>> -----Original Message-----
>>> From: Neil Franken [mailto:nfranken at theunlimitedworld.co.za]
>>> Sent: 18 June 2010 01:08 PM
>>> To: hobbit at hswn.dk
>>> Subject: RE: [hobbit] Booking new scripts into Xymon
>>>
>>> I did look at the FAQ in the site.
>>>
>>> -----Original Message-----
>>> From: Neil Franken [mailto:nfranken at theunlimitedworld.co.za]
>>> Sent: 18 June 2010 12:59 PM
>>> To: hobbit at hswn.dk
>>> Subject: RE: [hobbit] Booking new scripts into Xymon
>>>
>>> Hi All
>>>
>>> I registered on the http://xymonton.trantor.org site. I want to
upload
>>> my script but to be honest I am completely lost as how to do it. Is
>>> there instructions somewhere. Sorry this is my  first time with
>> DokuWiki
>>> and I don't want to mess up the site.  Any help will be appreciated.
>>>
>>>
>>> Regards
>>> Neil
>>>
>>>
>>> -----Original Message-----
>>> From: Neil Franken [mailto:nfranken at theunlimitedworld.co.za]
>>> Sent: 15 June 2010 08:17 AM
>>> To: hobbit at hswn.dk
>>> Subject: [hobbit] Booking new scripts into Xymon
>>>
>>> Hi All
>>>
>>> I am almost done with the scripts I talked about before. Is there
any
>>> special requirements to upload these to the Xymon community? Is
there
>> a
>>> QA function or something like that?
>>>
>>> Here is what I have:
>>> 1) ASP.NET overall health(VBS Script and graph definitions)
>>> 2) ASP.NET Application Specific Scripts (VBS Script and graph
>>> definitions)
>>> 3) SQL Server(Microsoft) DBA type performance pack (rather large
graph
>>> definition)
>>>
>>> On another note I have been able to interface with Xymon via telnet
>> and
>>> using Wireshark learned some basics about the protocol. Once I am a
>>> little more clued up I will upload some docs for the Wiki. At this
>> point
>>> I would also like to look at taking Xymon HTML pages a little
further.
>>> While AJAX and web 2.0 technologies would be great I feel that for
the
>>> moment I could probably add some value in making it a little easier
to
>>> customize via CSS. I am not a web designer by trade but I think I
can
>>> add some value in making this front end a little more configurable.
>>>
>>> Anyway if anyone can just let me know what the procedures  are for
>>> contributing to the project and I will gladly give the time that
xymon
>>> has saved me back into the project.
>>>
>>> Kind Regards
>>> Neil Franken
>>>
>>> To unsubscribe from the hobbit list, send an e-mail to
>>> hobbit-unsubscribe at hswn.dk
>>>
>>>
>>>
>>> To unsubscribe from the hobbit list, send an e-mail to
>>> hobbit-unsubscribe at hswn.dk
>>>
>>>
>>>
>>> To unsubscribe from the hobbit list, send an e-mail to
>>> hobbit-unsubscribe at hswn.dk
>>>
>>>
>>>
>>> To unsubscribe from the hobbit list, send an e-mail to
>>> hobbit-unsubscribe at hswn.dk
>>>
>>>
>>>
>>
>>
>>
>> To unsubscribe from the hobbit list, send an e-mail to
>> hobbit-unsubscribe at hswn.dk
>>
>>
>>
>> To unsubscribe from the hobbit list, send an e-mail to
>> hobbit-unsubscribe at hswn.dk
>>
>>
>>
>
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk
>
>



To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk



To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk