snmp informant. No Such Name (SNMP error # 2) ... again

Hello all,

Background infos: Running PRTG Network Monitor 8.4.1.2283 Using SNMP Informant Standard (free) and trying SNMP Informant Premium (Trial) for the SQL counters

When adding a SQL snmp OID, I keep getting the following error (snmp v1 or v2c) No Such Name (SNMP error # 2)

As far as I understand, it doesn’t find the object.

So from the PRTG server, I run the Paessler snmp tester (v3.2) I can retrieve all snmp OIDs as the snippet here under:

3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd active transactions: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.2
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd backup per restore throughput per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.3
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd bulk copy rows per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.4
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd bulk copy throughput per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.5
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd data filessizekb: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.7
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd dbcc logical scan bytes per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.6
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log bytes flushed per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.8
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log cache hit ratio: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.9
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log cache reads per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.10
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log filessizekb: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.11
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log filesused sizekb: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.12
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log flush wait time: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.13
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log flush waits per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.14
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log flushes per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.15
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log growths: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.16
3/04/2012 14:09:22 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log shrinks: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.17
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd log truncations: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.18
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring acks received per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.19
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring bytes sent per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.20
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring pages sent per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.21
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring sends per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.22
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring total acks received: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.23
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring total bytes sent: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.24
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring total pages sent: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.25
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring total sends: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.26
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd mirroring transaction delay: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.27
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd percent log used: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.28
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd repl pending xacts: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.29
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd repl trans rate: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.30
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd shrink data movement bytes per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.31
3/04/2012 14:09:23 INFORMANT-SQLSERVER|sql server databases: #[1.3.6.1.4.1.9600.1.3.16.1.2]|ssd transactions per sec: #[1.3.6.1.4.1.9600.1.3.27.1.1] 1.3.6.1.4.1.9600.1.3.27.1.32

As from the 1st line here above I try to add a custom snmp with OID: 1.3.6.1.4.1.9600.1.3.27.1.2 That I define it as Gauge unsigned or a float it doesn’t help.

All OID for the standard pack are working. None of the premium/SQL are.

For the sake of it here are the OID I retrieve with the standard snmp informant:

1.3.6.1.4.1.9600.1.1.1.1.13.6.95.84.111.116.97.108: INFORMANT-STD|logical disk: _Total|ldisk current disk queue length,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.67.58: INFORMANT-STD|logical disk: C:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.68.58: INFORMANT-STD|logical disk: D:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.69.58: INFORMANT-STD|logical disk: E:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.70.58: INFORMANT-STD|logical disk: F:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.71.58: INFORMANT-STD|logical disk: G:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.72.58: INFORMANT-STD|logical disk: H:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.73.58: INFORMANT-STD|logical disk: I:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.74.58: INFORMANT-STD|logical disk: J:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.76.58: INFORMANT-STD|logical disk: L:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.77.58: INFORMANT-STD|logical disk: M:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.78.58: INFORMANT-STD|logical disk: N:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.79.58: INFORMANT-STD|logical disk: O:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.80.58: INFORMANT-STD|logical disk: P:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.81.58: INFORMANT-STD|logical disk: Q:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.83.58: INFORMANT-STD|logical disk: S:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.84.58: INFORMANT-STD|logical disk: T:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.85.58: INFORMANT-STD|logical disk: U:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.86.58: INFORMANT-STD|logical disk: V:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.87.58: INFORMANT-STD|logical disk: W:|ldisk disk bytes per sec,Undefined,,(not defined),0
1.3.6.1.4.1.9600.1.1.1.1.14.2.88.58: INFORMANT-STD|logical disk: X:|ldisk disk bytes per sec,Undefined,,(not defined),0

Am I missing something here ?

Regards Stephane