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:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 12:06 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-1451852d21c5@xymon.invalid]
Sent: 21 June 2010 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
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:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 01:08 PM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Booking new scripts into Xymon
I did look at the FAQ in the site.
-----Original Message-----
From: Neil Franken [mailto:user-1689acfc5a3b@xymon.invalid]
Sent: 18 June 2010 12:59 PM
To: user-ae9b8668bcde@xymon.invalid
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:user-1689acfc5a3b@xymon.invalid]
Sent: 15 June 2010 08:17 AM
To: user-ae9b8668bcde@xymon.invalid
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