Windows 2000 / 2k3 Disk Statistics - upgrade issues

Templates, scripts for templates, scripts and requests for templates.

Moderators: Moderators, Developers

Author
Message
jpimentel
Posts: 39
Joined: Wed Jan 18, 2006 11:09 am

Windows 2000 / 2k3 Disk Statistics - upgrade issues

#1 Post by jpimentel » Tue Mar 14, 2006 10:12 am

Hi All,


In our environment we have application owners who have databases and programs running on powerful machines not utilizing the full potential of the hardware. To determine which machines are eligible to be moved over to a virtualized environment we use cacti as our reference point. Recently I was forced to upgrade cacti to h from g, because we were running into problems with gaps at the end of the graphs. ( http://forums.cacti.net/viewtopic.php?t ... highlight= ) Now one of the most important graphs no longer work. I have been working on this issue for over a week now with no luck. I hope one of you can help me with this.


I downloaded the script/template at http://forums.cacti.net/viewtopic.php?t ... ht=perfmon .
We are running cacti on a linux box using cmd.php as the poller.

VERBOS QUERY

+ Running data query [12].
+ Found type = '3' [snmp query].
+ Found data query XML file at '/var/www/html/cacti-0.8.6g/resource/snmp_queries/snmp_informant_disk.xml'
+ XML file parsed ok.
+ Executing SNMP walk for list of indexes @ '.1.3.6.1.4.1.9600.1.1.1.1.1'
+ Located input field 'diskInstance' [walk]
+ Executing SNMP walk for data @ '.1.3.6.1.4.1.9600.1.1.1.1.1'
+ Found item [diskInstance='C:'] index: 2.67.58 [from value]
+ Found item [diskInstance='_Total'] index: 1.3.6.1.4.1.9600.1.1.1.1.1.6.95.84.111.116.97.108 [from value]
+ Found data query XML file at '/var/www/html/cacti-0.8.6g/resource/snmp_queries/snmp_informant_disk.xml'
+ Found data query XML file at '/var/www/html/cacti-0.8.6g/resource/snmp_queries/snmp_informant_disk.xml'
+ Found data query XML file at '/var/www/html/cacti-0.8.6g/resource/snmp_queries/snmp_informant_disk.xml'
+ Found data query XML file at '/var/www/html/cacti-0.8.6g/resource/snmp_queries/snmp_informant_disk.xml'



GRAPH DEBUG

RRDTool Command:
/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="test123 - Disk Stats |query_diskInstance|" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="Unit (Percent / time slice)" \
DEF:a="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":PercentDiskReadTime:LAST \
DEF:b="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":PercentDiskWriteTim:LAST \
DEF:c="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":AvgDiskReadQueueLen:LAST \
DEF:d="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":AvgDiskWriteQueueLe:LAST \
DEF:e="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":PercentFreeSpace:LAST \
DEF:f="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":PercentDiskReadTime:LAST \
DEF:g="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":AvgDiskReadPerSec:LAST \
DEF:h="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":AvgDiskWritePerSec:LAST \
DEF:i="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":PercentFreeSpace:LAST \
DEF:j="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":FreeMegabytes:LAST \
DEF:ba="/var/www/html/cacti-0.8.6g/rra/test123_avgdiskwritequeuele_1980.rrd":FreeMegabytes:LAST \
CDEF:cdefbe=ba,1024,/ \
CDEF:cdefdc=ba,1048576,/ \
CDEF:cdefdd=a,0,*,100,+ \
AREA:f#FF6044:"Read Time(%)" \
AREA:b#00BED9:"Write Time(%)" \
LINE1:c#F5F800:"Read Queue\:" \
LINE1:d#00FF00:"Write Queue\:\n" \
LINE2:i#000000:"" \
LINE1:f#000000:"" \
LINE1:g#0000FF:"Read /s\:" \
LINE1:h#DE0056:"Write /s" \
LINE1:i#000000:"Free Space (%)\n" \
COMMENT:"Statistics" \
GPRINT:f:LAST:" Read\: (%1.1lf %%)" \
GPRINT:b:LAST:"Write\: (%1.1lf %%)" \
GPRINT:i:LAST:"Free\: (%1.1lf %%)" \
LINE1:ba:"Available\:" \
GPRINT:cdefbe:LAST:" Available \: %5.2lf Gb\n" \
COMMENT:"Read IO / sec:" \
GPRINT:g:LAST:" Current\:%8.0lf" \
GPRINT:g:AVERAGE:"Average\:%8.0lf" \
GPRINT:g:MAX:"Maximum\:%8.0lf\n" \
COMMENT:"Write IO / sec:" \
GPRINT:h:LAST:" Current\:%8.0lf" \
GPRINT:h:AVERAGE:"Average\:%8.0lf" \
GPRINT:h:MAX:"Maximum\:%8.0lf\n" \
COMMENT:"Read Queue:" \
GPRINT:c:LAST:" Current\:%8.0lf" \
GPRINT:c:AVERAGE:"Average\:%8.0lf" \
LINE1::"Free Space (Mb)" \
GPRINT:c:MAX:" Maximum\:%8.0lf\n" \
COMMENT:"Write Queue:" \
GPRINT:d:LAST:" Current\:%8.0lf" \
GPRINT:d:AVERAGE:"Average\:%8.0lf" \
GPRINT:d:MAX:"Maximum\:%8.0lf\n" \
LINE1:cdefdc#FFFFFF:"" \
LINE1:cdefdd#FFFFFF:""
RRDTool Says:
ERROR: can't parse ':Free Space (Mb)'
JP

tgk
Posts: 28
Joined: Sat Mar 11, 2006 10:46 pm

#2 Post by tgk » Tue Mar 14, 2006 8:44 pm

It seems your 9th LINE1 doesn't have a data source. Check it in your graph template.

LINE1::"Free Space (Mb)" \

jpimentel
Posts: 39
Joined: Wed Jan 18, 2006 11:09 am

#3 Post by jpimentel » Wed Mar 15, 2006 9:17 am

The datasource is selected. :S
Attachments
datasource.JPG
datasource.JPG (140.65 KiB) Viewed 37289 times
JP

tgk
Posts: 28
Joined: Sat Mar 11, 2006 10:46 pm

#4 Post by tgk » Wed Mar 15, 2006 9:23 am

It's not that one, but the one with "Free Space (Mb)" in the "Text Format" field.
Your screenshot is from the "Free Space (%)" field.

jpimentel
Posts: 39
Joined: Wed Jan 18, 2006 11:09 am

#5 Post by jpimentel » Wed Mar 15, 2006 2:20 pm

I made the change you suggested and my graph finally appeared. This is what my graph looks like now, but seems that there is no lines being graphed. Reading the original document it said somthing about a color not being assigned, but I was not sure where to make the change. Do you think this is why the graph is not showing any lines?
Attachments
image.JPG
image.JPG (52.22 KiB) Viewed 37268 times
JP

tgk
Posts: 28
Joined: Sat Mar 11, 2006 10:46 pm

#6 Post by tgk » Wed Mar 15, 2006 3:29 pm

No, I think your problem is scale. Your vertical scale goes up to 40000. You are probably graphing the available disk space (instead of %), or something huge, together with tiny numbers like writes per sec.

jpimentel
Posts: 39
Joined: Wed Jan 18, 2006 11:09 am

#7 Post by jpimentel » Wed Mar 15, 2006 4:34 pm

Okay I change the auto scale options to use ( --alt-autoscale-max )
and unselected ""auto scale"". My graph looks much better than it originally did.


What I would like to do is have all the legend (colors/names) info line up at the left side and statics r/w on the right side.
Can you provide me an example on how to do that? Once this template is complete I will upload the final copy on the original post.

http://forums.cacti.net/viewtopic.php?t ... ht=perfmon
Attachments
image.JPG
image.JPG (57.45 KiB) Viewed 37223 times
cacti_data_template_w32_disk_statistics.xml
(10.83 KiB) Downloaded 2362 times
cacti_graph_template_w32_disk_statistics.xml
(34.93 KiB) Downloaded 2243 times
snmp_informant_disk.xml
(38.36 KiB) Downloaded 2665 times
JP

tgk
Posts: 28
Joined: Sat Mar 11, 2006 10:46 pm

#8 Post by tgk » Thu Mar 16, 2006 9:30 am

I had the same problem with that template. I finally found that it looks great if you are using RRDTool 1.2 (which uses nicer and smaller fonts, and font size can be adjusted), but looks like your screenshot with RRDTool 1.0.
Realigning it will take you a while. You'll have to go to the Graph Template and move the LINE and GPRINT lines up and down, add a few Hard Returns, etc.
It's much easier (and completely worth it) to upgrade to RRDTool 1.2. If you do, remember to go to Settings and change the version there.

jpimentel
Posts: 39
Joined: Wed Jan 18, 2006 11:09 am

#9 Post by jpimentel » Thu Mar 16, 2006 12:28 pm

Thanks a lot, I will make that change, and when complete I will post my new graph.
JP

User avatar
Khan
Posts: 48
Joined: Mon Nov 03, 2003 11:08 am
Location: Madtown, WI

#10 Post by Khan » Mon Apr 10, 2006 11:26 am

jpimentel wrote:Thanks a lot, I will make that change, and when complete I will post my new graph.
jpimentel,
Were you able to get this graph to show up correctly? And if so, can you please post the final scripts/xml files? Thanks.

jpimentel
Posts: 39
Joined: Wed Jan 18, 2006 11:09 am

#11 Post by jpimentel » Mon Apr 10, 2006 8:41 pm

My graph at the momment does not look any better. I am still working on it, and will post as soon as its complete.
JP

User avatar
Khan
Posts: 48
Joined: Mon Nov 03, 2003 11:08 am
Location: Madtown, WI

#12 Post by Khan » Mon Apr 10, 2006 9:45 pm

jpimentel wrote:My graph at the momment does not look any better. I am still working on it, and will post as soon as its complete.
Good deal. I'll keep an eye on this thread. Thanks for the quick reply and good luck with the graph.

dt9394
Posts: 3
Joined: Mon Apr 10, 2006 10:13 pm

soft "patching"?

#13 Post by dt9394 » Mon Apr 10, 2006 10:47 pm

I found a way how to make the graph show up.

1) remove snmp_disk_informant data & graph template

2) import data template then graph template (original with lack of legend color)

3) create your device graph.

4)After creating your graph go to grapgh management and turn on graph debug. And u will notice some legen color not available warning.

5) download the graph template with all the legend color then re-import again (do not remove the original grapgh template)

6) done... after u go back to graph debug option it will tell u all ok

7) auto scale = off , alt-sclae-max = on

8) happy cacti-ing :D

ynot5
Posts: 16
Joined: Mon Jul 24, 2006 3:15 am

graph template

#14 Post by ynot5 » Thu Aug 24, 2006 5:07 am

made some adjustments
Attachments
cacti_graph_template_w32_disk_statistics.xml
(34.3 KiB) Downloaded 1978 times

JonMikel
Posts: 16
Joined: Mon Jul 02, 2007 2:51 am

#15 Post by JonMikel » Tue Jul 10, 2007 4:03 am

Hello, i don't know how to solve the problem have anyone done it??

In fact, i can see the graph and it seems that everithing's right but if i zoom it, i can't see anything!!
Attachments
graph.png
graph.png (16.84 KiB) Viewed 31610 times
zoom.png
zoom.png (21.74 KiB) Viewed 31610 times
|| SUSELinux 10.1 || Cacti 0.8.6h-15.2 || PHP 5.1.2-27 || MySQL 5.0.18-16 || RRDTools 1.2.12-13 ||
Monitoring Windows servers with SNMP Informant.

Post Reply