My attempt to create new graphs

[edgonz]

First off, I think there's an issue with the document links on the main Cacti website, so I can't reference that for now.

I created a VBS script that reports some SQL information:

Code: Select all

SQLCacheMemoryKB: 6992
TotalServerMemoryKB: 12812616

So far, my graphs can report on SQL cache memory, but for some reason the sql total memory is not graphed and I can't figure this one out.

I'm sure I'm missing something somewhere.

Thanks.

[gandalf]

Sorry about the crash of cacti sites. Unfortunately, you will find my "NaN Debugging Guide" there, linked in the second entry of my signature.
For 087(a), it is part of the html docu provided with cacti (./docs/html)
Reinhard

[edgonz]

Ok, I've read the "Not NaN, but 0 (zero) values?" section, but I'm still unable to figure this thing out.

I've set my logs to detailed view and can't seem to find any clues as to what might be causing this.

I can run the vbs script as cactiuser, so I know this isn't a permission issue.

[gandalf]

My howto shows how to find the data returned from the script in cacti.log. I need a copy of that very bit, please
Reinhard

[Alice]

i think it should spit the info like this:

SQLCacheMemoryKB:6992 TotalServerMemoryKB:12812616

All on a single line, and take care about the spaces.

[edgonz]

Ok, after going through your HOWTO's this is something I found:

Code: Select all

c:\rrdtool\rrdtool info sqlserver1_totalservermemorykb_6071.rrd
filename = "sqlserver1_totalservermemorykb_6071.rrd"
rrd_version = "0003"
step = 300
last_update = 1196282588
ds[TotalServerMemoryKB].type = "GAUGE"
ds[TotalServerMemoryKB].minimal_heartbeat = 600
ds[TotalServerMemoryKB].min = 0.0000000000e+000
ds[TotalServerMemoryKB].max = 2.0000000000e+007
ds[TotalServerMemoryKB].last_ds = "U"
ds[TotalServerMemoryKB].value = NaN
ds[TotalServerMemoryKB].unknown_sec = 188
ds[SQLCacheMemoryKB].type = "GAUGE"
ds[SQLCacheMemoryKB].minimal_heartbeat = 600
ds[SQLCacheMemoryKB].min = 0.0000000000e+000
ds[SQLCacheMemoryKB].max = NaN
ds[SQLCacheMemoryKB].last_ds = "5984"
ds[SQLCacheMemoryKB].value = 1.1249920000e+006
ds[SQLCacheMemoryKB].unknown_sec = 0
rra[0].cf = "AVERAGE"
rra[0].rows = 500
rra[0].pdp_per_row = 1
rra[0].xff = 5.0000000000e-001
rra[0].cdp_prep[0].value = NaN
rra[0].cdp_prep[0].unknown_datapoints = 0
rra[0].cdp_prep[1].value = NaN
rra[0].cdp_prep[1].unknown_datapoints = 0
rra[1].cf = "AVERAGE"
rra[1].rows = 600
rra[1].pdp_per_row = 1
rra[1].xff = 5.0000000000e-001
rra[1].cdp_prep[0].value = NaN
rra[1].cdp_prep[0].unknown_datapoints = 0
rra[1].cdp_prep[1].value = NaN
rra[1].cdp_prep[1].unknown_datapoints = 0
rra[2].cf = "AVERAGE"
rra[2].rows = 700
rra[2].pdp_per_row = 6
rra[2].xff = 5.0000000000e-001
rra[2].cdp_prep[0].value = NaN
rra[2].cdp_prep[0].unknown_datapoints = 2
rra[2].cdp_prep[1].value = 1.1981013333e+004
rra[2].cdp_prep[1].unknown_datapoints = 0
rra[3].cf = "AVERAGE"
rra[3].rows = 775
rra[3].pdp_per_row = 24
rra[3].xff = 5.0000000000e-001
rra[3].cdp_prep[0].value = NaN
rra[3].cdp_prep[0].unknown_datapoints = 8
rra[3].cdp_prep[1].value = 4.7768960000e+004
rra[3].cdp_prep[1].unknown_datapoints = 0
rra[4].cf = "AVERAGE"
rra[4].rows = 797
rra[4].pdp_per_row = 288
rra[4].xff = 5.0000000000e-001
rra[4].cdp_prep[0].value = 0.0000000000e+000
rra[4].cdp_prep[0].unknown_datapoints = 247
rra[4].cdp_prep[1].value = 2.9163278067e+005
rra[4].cdp_prep[1].unknown_datapoints = 201
rra[5].cf = "MAX"
rra[5].rows = 500
rra[5].pdp_per_row = 1
rra[5].xff = 5.0000000000e-001
rra[5].cdp_prep[0].value = NaN
rra[5].cdp_prep[0].unknown_datapoints = 0
rra[5].cdp_prep[1].value = NaN
rra[5].cdp_prep[1].unknown_datapoints = 0
rra[6].cf = "MAX"
rra[6].rows = 600
rra[6].pdp_per_row = 1
rra[6].xff = 5.0000000000e-001
rra[6].cdp_prep[0].value = NaN
rra[6].cdp_prep[0].unknown_datapoints = 0
rra[6].cdp_prep[1].value = NaN
rra[6].cdp_prep[1].unknown_datapoints = 0
rra[7].cf = "MAX"
rra[7].rows = 700
rra[7].pdp_per_row = 6
rra[7].xff = 5.0000000000e-001
rra[7].cdp_prep[0].value = NaN
rra[7].cdp_prep[0].unknown_datapoints = 2
rra[7].cdp_prep[1].value = 5.9920000000e+003
rra[7].cdp_prep[1].unknown_datapoints = 0
rra[8].cf = "MAX"
rra[8].rows = 775
rra[8].pdp_per_row = 24
rra[8].xff = 5.0000000000e-001
rra[8].cdp_prep[0].value = NaN
rra[8].cdp_prep[0].unknown_datapoints = 8
rra[8].cdp_prep[1].value = 5.9920000000e+003
rra[8].cdp_prep[1].unknown_datapoints = 0
rra[9].cf = "MAX"
rra[9].rows = 797
rra[9].pdp_per_row = 288
rra[9].xff = 5.0000000000e-001
rra[9].cdp_prep[0].value = 0.0000000000e+000
rra[9].cdp_prep[0].unknown_datapoints = 247
rra[9].cdp_prep[1].value = 6.3120000000e+003
rra[9].cdp_prep[1].unknown_datapoints = 201

I also found this in the logs:

Code: Select all

11/28/2007 04:08:00 PM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Potential Data Source Issues for Data Sources: (DS[6071])

DS6071 points to:
c:/rrdtool/rrdtool.exe create \
C:/Inetpub/wwwroot/cacti/rra/sqlserver1_totalservermemorykb_6071.rrd \
--step 300 \
DS:TotalServerMemoryKB:GAUGE:600:0:20000000 \
DS:SQLCacheMemoryKB:GAUGE:600:0:U \
RRA:AVERAGE:0.5:1:500 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \


I don't know if this can help in any way. I see a few NaN in there.

[edgonz]

i think it should spit the info like this:

SQLCacheMemoryKB:6992 TotalServerMemoryKB:12812616

All on a single line, and take care about the spaces.

Hmm, I have it showing the output on two lines, that may be it. I'm going to modify my script.

[gandalf]

i think it should spit the info like this:

SQLCacheMemoryKB:6992 TotalServerMemoryKB:12812616

All on a single line, and take care about the spaces.

Oops, missed that. You're quite right
Reinhard