Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
That wasn't the best log file to use, I was playing around trying to get it to work the other day. I still get the same behavior when I use the proper counter definition.
As for perf32, that works great. The only problem is, I can't query something that has parenthesis in the name...
SQLServer:Databases\DataFile(s) Size (KB)\_Total returns "null" but SQLServer:Databases\Active Transactions\_Total works just fine. It appears a lot of SQL counters use () in their name....
Thanks again for the help, this is going to be quite handy.
-Kyle
Regarding perf32.exe, nice bug : I'll fix it quickly.
Thanks for the debugging !
Regards,
Erwan.
edit : about perf32.exe, you may find the right counter syntax with the following command lines :
perf32 /enumobjects
perf32 "SQLServer:Databases" /enumobjectitems
the return for this is the full result of the pinging progress like this
snmpget -v 2c -c public host.eee.cc 1.3.6.1.4.1.15.5
Pinging yahoo.com [206.190.60.37] with 32 bytes of data:
Reply from 206.190.60.37: bytes=32 time=211ms TTL=53
Ping statistics for 206.190.60.37:
Packets: Sent = 1, Received = 1, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 211ms, Maximum = 211ms, Average = 211ms
so how can i get this to work and only graph the 211ms if in the above example
I believe this one is right
12:56:50:070 , GetRequest: OID=1.3.6.1.4.1.15.1 (
12:56:51:257 , Value=410 asn_type=2
(although this is a lot of users!)
not this one
12:58:49:759 , MakePath ok :\SQLServer:General Statistics\User Connections
12:58:50:759 , Value=0 asn_type=2
I have been reported that 64bits applied to counters does not work yet :
integer values always report 0 and float values report out of range figures.
About the leading ":", it is only a log display issue.
The good thing is that you have a workaround to get performance values against a windows server 64bits via snmp (using perf32.exe).
Bad thing is that I need to understand how pointers work in 64bits dev
Soon, snmptools 64bits will natively support performance counters without having to use a 32bits executable.
Regards,
Erwan
edit1 : you may try
[1.3.6.1.4.1.15.2]
flag=raw
counter=SQLServer:General Statistics\User Connections
in order to retrieve a raw value instead of a formatted value.
This will always return int64 values. (not float thus).
Maybe the pdh API in use then will behave better.
You're correct, 410 is right (it also shows up as 410 in perfmon). That's our main SQL server for our ERP software so that's about normal.
Things are working great with perf32, I'm getting all kinds of good data into cacti now. Thanks again for all your help and work on this. That's gonna be a pretty popular tool I predict!
Hi Ky,
I'm glad to see it is working for you in 64bits mode.
Note that you can use the 32bits version under win64 (I just found this out).
Delete (or rename) the old snmptools registry key and create that one :
(and put the snmptools.dll 32bits version in your windows folder, not system32).
more details here : http://erwan.l.free.fr/snmptools/#64bits .
This way you can benefit from the more debugged 32bits version.
On the other side, the 64bits is native and is almost complete.
For performance counters returning dword values (not float) and not requiring calculations (like your sql number of users), add the following flag :
This will return the correct raw performance counter value and specifically the hi part (dword) part of the int64 value.
This is a limited workaround for a bug in the snmptools64.dll and 32bits values in 64bits variables.
Regards,
Erwan.
edit1 : you need latest version 2.0.0.5 .
edit2 : Ky, dont hesitate to post graphs you get via snmptools.
This could help other users.
edit3 : note that by default, the snmp agent will take 1 sec to return as it will collect two set of datas (for counters that require calculation).
you can have the snmp agent return the value immediately like this :
I gave the WOW6432 method a shot, first deleting the original keys and starting from there. After getting the .dll in place, importing the regagentWOW6432.reg, and restarting the SNMP service I got no response (no log with debug=1, no response to 1.3.6.1.4.1.15, etc). I did notice the [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SNMP\Parameters\ExtensionAgents] key is not in the WOW6432 registry file, does it need to be to work properly? I switched back to 64bit and all is well again.
As far as the flag=raw,hi workaround goes I am having some strange behavior.
For this:
[1.3.6.1.4.1.15.9]
counter=Processor\% Processor Time\_Total
I get 1.31878521153509E-282 (not correct).
For this:
[1.3.6.1.4.1.15.9]
flag=raw,hi
counter=Processor\% Processor Time\_Total
I get -533325531 (not correct).
I think I'll just stick with the 64bit version and try to help you with the debugging process.
I will definitely post some graphs once I get everything situated. Thanks as always.
-Kyle
Indeed, so far, the 64bits version works only with the flag=raw,hi and only with dword values (not float ones), which makes it limited so far...
For instance, the following counter will work under win64 with these flags:
counter=LogicalDisk\Free Megabytes\_Total. (dword value).
About snmptools, as any snmp agent, it needs 2 part in the registry :
1/ (the name of the agent to load and where in the registy to find the pathname)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SNMP\Parameters\ExtensionAgents]
"snmptools"="SOFTWARE\\snmptools\\CurrentVersion"
2/ (the path where to find the agent and some other agent details)
[HKEY_LOCAL_MACHINE\SOFTWARE\snmptools\currentversion]
"Pathname"="%systemroot%\\snmptools.dll"
"counters"="c:\\counters.ini"
This is is true on win32 and win64 platform.
But on win64, you can also load 32bits agents by altering step 2 above and modifying this key:
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\snmptools\currentversion]
"counters"="c:\\counters.ini"
This will tell windows to load the agent using the 32bits snmp.exe (will show as snmp *32 in the tasklist).
And you are right : I checked the registry file, it was wrong
I exported it from my win64 server (where the 32bits agent is working) but I forgot to also export the first part...
I updated the zip file and reuploaded it.
Thanks for pointing this out as it may help other using the 32bits version on win64.
Thanks also for sticking to the 64bits version so that I may have a chance to fix the counters value bug.
In the meantime, I am glad that perf32.exe does its job
Thankyou for creating this dll as it is exactly the thing we have been looking for.
I have come across an issue though and im not sure if its to do with snmptools or with cacti.
We have cacti 0.8.7b and I am using the 32bit version of snmptools with our 64bit 2003 servers because i was getting some strange results with the 64bit version of the dll.
The odd thing happens when i set Cacti to poll using spine. The Cacti log shows the following
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1506] SNMP: v2: 172.16.11.154, dsname: pmProcTime1, oid: .1.3.6.1.4.1.15.2.1.2, value: 0
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1507] WARNING: Result from SNMP not valid. Partial Result: ...
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1507] SNMP: v2: 172.16.11.154, dsname: pmProcTime2, oid: .1.3.6.1.4.1.15.2.1.3, value: U
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1508] WARNING: Result from SNMP not valid. Partial Result: ...
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1508] SNMP: v2: 172.16.11.154, dsname: pmProcTimeTot, oid: .1.3.6.1.4.1.15.2.1.1, value: U
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1509] WARNING: Result from SNMP not valid. Partial Result: ...
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1509] SNMP: v2: 172.16.11.154, dsname: pmPrivBytesSqlSvr, oid: 1.3.6.1.4.1.15.3.2.1, value: U
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1510] WARNING: Result from SNMP not valid. Partial Result: ...
09/10/2008 09:50:10 AM - SPINE: Poller[0] Host[136] DS[1510] SNMP: v2: 172.16.11.154, dsname: pmProcTimeSqlSvr, oid: 1.3.6.1.4.1.15.3.1.1, value: U
when i switch on debug mode in snmptools the log file shows the following.
09:50:10:448 , Value=0 asn_type=2
09:50:10:448 , GetRequest OK
09:50:10:448 , SnmpExtensionQueryEx
09:50:10:448 , nRequestType=SNMP_EXTENSION_GET
09:50:10:463 , GetRequest: OID=1.3.6.1.4.1.15.2.1.2 (10)
09:50:10:463 , path=Processor\% Processor Time\0
09:50:10:463 , MakePath ok :\Processor(0)\% Processor Time
09:50:11:463 , Value=0 asn_type=2
09:50:11:463 , GetRequest OK
09:50:11:463 , nRequestType=SNMP_EXTENSION_GET
09:50:11:463 , GetRequest: OID=1.3.6.1.4.1.15.2.1.2 (10)
09:50:11:463 , path=Processor\% Processor Time\0
09:50:11:479 , MakePath ok :\Processor(0)\% Processor Time
09:50:12:479 , Value=4.68261975013121 asn_type=4
09:50:12:479 , GetRequest OK
09:50:12:479 , nRequestType=SNMP_EXTENSION_GET
09:50:12:479 , GetRequest: OID=1.3.6.1.4.1.15.2.1.2 (10)
09:50:12:495 , path=Processor\% Processor Time\0
09:50:12:495 , MakePath ok :\Processor(0)\% Processor Time
09:50:13:495 , Value=3.120039746035 asn_type=4
09:50:13:495 , GetRequest OK
09:50:13:526 , nRequestType=SNMP_EXTENSION_GET
09:50:13:541 , GetRequest: OID=1.3.6.1.4.1.15.2.1.2 (10)
09:50:13:557 , path=Processor\% Processor Time\0
09:50:13:573 , MakePath ok :\Processor(0)\% Processor Time
09:50:14:588 , Value=1.55745974193878 asn_type=4
09:50:14:588 , GetRequest OK
09:50:14:604 , nRequestType=SNMP_EXTENSION_GET
09:50:14:604 , GetRequest: OID=1.3.6.1.4.1.15.2.1.2 (10)
09:50:14:619 , path=Processor\% Processor Time\0
09:50:14:619 , MakePath ok :\Processor(0)\% Processor Time
09:50:15:635 , Value=1.55745974193878 asn_type=4
09:50:15:635 , GetRequest OK
However if i switch over to using cmd.php i see the following type of entries in the cacti log. (i have not included every entry here)
09/10/2008 10:13:31 AM - CMDPHP: Poller[0] Host[136] DS[1509] SNMP: v2: 172.16.11.154, dsname: pmPrivBytesSqlSvr, oid: 1.3.6.1.4.1.15.3.2.1, output: 1804632064
09/10/2008 10:13:31 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1509, 'pmPrivBytesSqlSvr', '2008-09-10 10:13:24', '1804632064')"
09/10/2008 10:13:33 AM - CMDPHP: Poller[0] Host[136] DS[1510] SNMP: v2: 172.16.11.154, dsname: pmProcTimeSqlSvr, oid: 1.3.6.1.4.1.15.3.1.1, output: 1.56258000409621
09/10/2008 10:13:33 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_output (local_data_id, rrd_name, time, output) values (1510, 'pmProcTimeSqlSvr', '2008-09-10 10:13:24', '1.56258000409621')"
09/10/2008
This is all correct and i get graphs. The only problem is that we need to use spine because of the number of items being monitored and things get missed if i use cmd.php.
It looks as though spine is sending query requests to the server correctly but is not recieving back correct responses. The only difference i can see is that spine is sending a group of requests at the same time where as cmd.php sends them a second or two appart. Is snmptools getting confused by multiple requests at the same time and then just responds to all requests with the result of the first one?
If you can provide any help it would be much appreciated as this dll you have created is of massive benefit to us.
