Windows 2000 / 2k3 Disk Statistics

joshm · Cacti User Joined: 03 Oct 2005 Posts: 62 Location: STL

Thanks for posting but still having issues with these graphs... A debug of the graph and I get the following...

RRDTool Command:

n:/rrdtool/rrdtool.exe graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="AlphaSQL (SQL3) - Disk - E:" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="Unit (Percent / time slice)" \
--slope-mode \
--font TITLE:10:c:/winnt/fonts/timesbd.ttf \
--font AXIS:9:c:/winnt/fonts/arial.ttf \
--font LEGEND:11:c:/winnt/fonts/arial.ttf \
--font UNIT:9:c:/winnt/fonts/arial.ttf \
DEF:a="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":PercentDiskReadTime:LAST \
DEF:b="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":PercentDiskWriteTim:LAST \
DEF:c="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":AvgDiskReadQueueLen:LAST \
DEF:d="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":AvgDiskWriteQueueLe:LAST \
DEF:e="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":PercentFreeSpace:LAST \
DEF:f="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":PercentDiskReadTime:LAST \
DEF:g="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":AvgDiskReadPerSec:LAST \
DEF:h="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":AvgDiskWritePerSec:LAST \
DEF:i="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":PercentFreeSpace:LAST \
DEF:j="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":FreeMegabytes:LAST \
DEF:ba="N\:/cacti/rra/alphasql_sql3_avgdiskreadqueuelen_762.rrd":FreeMegabytes:LAST \
CDEF:cdefbd=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 %%)" \
GPRINT:cdefbd:AVERAGE:"Available \: %5.2lf Gb\n" \
LINE1:ba:"Available\:" \
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" \
GPRINT:c:MAX:"Maximum\:%8.0lf\n" \
LINE1::"Free Space (Mb)" \
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: Legend set but no color: Available\:

Cancel

dust2k · Cacti User Joined: 04 Dec 2005 Posts: 85

Oooops, I found that one have some problem, here is the new one, but both of them works for me, I use poller.php instead of cactid.

after you import the graph template, you may need go to each graph to re-mapping those data source fields.

phantom_rgs · Joined: 16 Jan 2006 Posts: 38 Location: Brasil

in my hosts the graphs are show as broken

what i do?

BobDole · Joined: 03 Dec 2005 Posts: 2

I'm also getting errors:

[cut out details]
RRDTool Says:

ERROR: Legend set but no color: \n

I just upgraded to 0.8.6h this morning and these graphs broke. I've imported the last updated template that was posted but no luck.

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

The graph breaks with h, its simple to fix though and has been discussed above.

Just goto graph templates, click on the right one, one of the line items won't have a colour associated with it, click on that item and assign a colour. Ry viola, your graph should work.

Argon0

BobDole · Joined: 03 Dec 2005 Posts: 2

argon0 · Cacti User Joined: 12 Mar 2004 Posts: 238

Can you post your Graph Debug here please?

EC · Joined: 06 Mar 2006 Posts: 5

kelbyc · Joined: 28 Nov 2005 Posts: 44

Has anyone finally got this workign with 0.8.6h?? If so can you please post your data query template and graph template? I've tried this version and one from another post but 0.8.6h just won't do it. The graphs show up as a red X. Everything seems to be right and I even assigned a color to every graph item but I still get the red X.

dt9394 · Joined: 10 Apr 2006 Posts: 3

my graph sometime is "corrupted" especially the "Available" value in rra file is misplaced.
anyone have the same problem?

usefulidiot010 · Joined: 14 Apr 2006 Posts: 1

this seems like a really useful graph and seems to run the snmp query correctly yet for some reason the RRA is never created on my system.

is anyone else having issues running 0.8.6h where it is not creating the RRA?

mikesphar · Joined: 19 Apr 2006 Posts: 6 Location: Chicago, IL

Well, I'm having trouble with this too, I've update the color for the line item that didn't have it, but I'm now getting this error:

kokkers · Joined: 16 Feb 2006 Posts: 6

Man, did I have some troubles installing this template

With all its nice and flexible features Cacti is getting way too complex for the average user.
Alot of users start with Cacti without any experience in using SNMP / RRDtool or scripting whatsoever.

It is just hard to get the needed system feedback when stuff is not working as intended.

That being off my chest, this is what I had to do to get the template working properly.

(I have a running 0.8.6h Cacti environment)

- Had to fiddle with the template, manually setting the colors.
- Got rid of the free disk space (not relevant, clogging screen)
- Restructure the template, so the now crippled legend looks nice again.
- Cacti would somehow not create the corresponding RRD's (even after waiting a few cycles, fiddled some more and got it fixed)
- Read and write queue length would not get updated in the RRD (display as NaN). I had to change the OID in the data query template after looking it up doing a manual snmpwalk.
x.x.x.x.8 and x.x.x.x.x.9, had to be changed to x.x.x.x.11 and x.x.x.x.x.12
(Dont forget to reset the xml file in the dataquery settings overview!)

Hours later I got 6 working graphs...

\ o /

For what it's worth, I attached my w32_disk_template.

mikesphar · Joined: 19 Apr 2006 Posts: 6 Location: Chicago, IL

I think part of the problem at least I was having was that the updated "corrected" templates provided by people later in this thread didn't include the data query templates. And when I imported the original data query templates along with the new updated "fixed" graph templates, you end up with a seriously munged up graph template, or at least I did.

I finally went through the whole graph template and re-ordered many items and deleted others to get it to actually look like the samples provided. Also one of the CDEFs from one of the templates seemed to have some sort of typo in it that was causing an RPN Stack Underflow error for me.

I do think I've got it mostly sorted out now, but I'm watching the stats for a while to make sure I like what I'm getting.

If nothing else, getting these templates actually working has been something of a crash course in cacti customization.