Windows 2000 / 2k3 Disk Statistics - upgrade issues

jpimentel · Joined: 18 Jan 2006 Posts: 38

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=12067&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=10707&highlight=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)'

tgk · Joined: 11 Mar 2006 Posts: 28

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

jpimentel · Joined: 18 Jan 2006 Posts: 38

The datasource is selected. :S

tgk · Joined: 11 Mar 2006 Posts: 28

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 · Joined: 18 Jan 2006 Posts: 38

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?

tgk · Joined: 11 Mar 2006 Posts: 28

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 · Joined: 18 Jan 2006 Posts: 38

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=10707&highlight=perfmon

tgk · Joined: 11 Mar 2006 Posts: 28

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 · Joined: 18 Jan 2006 Posts: 38

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

Khan · Joined: 03 Nov 2003 Posts: 47 Location: Madtown, WI

jpimentel · Joined: 18 Jan 2006 Posts: 38

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

Khan · Joined: 03 Nov 2003 Posts: 47 Location: Madtown, WI

dt9394 · Joined: 10 Apr 2006 Posts: 3

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

happy cacti-ing

ynot5 · Joined: 24 Jul 2006 Posts: 16

made some adjustments

JonMikel · Joined: 02 Jul 2007 Posts: 16

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!!