[hobbit] Booking new scripts into Xymon

Walter van Loon hobbit at general-failure.com
Mon Jun 21 12:06:06 CEST 2010


One of our DBA's modified the script from

strOutput = strOutput &
CheckReverseValue(GetWMIPercent("Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager","@","Buffercachehitratio","Buffercachehitratio_Base"),"Buffer
Cache Hit Ratio",iBufferCacheHitRatioWarn, iBufferCacheHitRatioAlarm)

to

strOutput = strOutput &
CheckReverseValue(GetWMIValue("Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferManager","@","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
>
>





More information about the Xymon mailing list