[mrtg] Monitoring SQL server

[Tendolkar Mohit]

 Hi,

For Windows systems with SQL server installed, one can monitor SQL
performance via the MSSQLSERVER-MIB.

I was trying to monitor some of its parameters using MRTG and to my
surprise, an SNMP Get-NEXT works on some of its objects, but an SNMP Get
fails on the same instance! As a result MRTG keeps generating errors.
Guess this is the side effect of complicating matters by having a table
indexed on a string!

For instance, below is a dump from a generic SNMP tool

// NOTE the following Get NEXT works
snmptool getnext TX_FSM public .1.3.6.1.4.1.311.1.4.1.1.2.1.19

SnmpTool - Simple Network Management Protocol Tool for Win32


Performing branch walk starting at OID 1.3.6.1.4.1.311.1.4.1.1.2.1.19


         Name:
.iso.org.dod.internet.private.enterprises.microsoft.software.4.1.
1.2.1.19.6.116.120.95.102.115.109
          OID: 1.3.6.1.4.1.311.1.4.1.1.2.1.19.6.116.120.95.102.115.109
         Type: Gauge
        Value: 0


// NOTE the following GET for the instance returned by the same agent
above does not work
snmptool get tx_fsm public .1.3.6.1.4.1.311.1.4.1.1.2.1.19.6.116.120.95
.102.115.109

SnmpTool - Simple Network Management Protocol Tool for Win32

  ErrorStatus: 2 (No such variable name)
   ErrorIndex: 1

    varbind 1:
         Name:
.iso.org.dod.internet.private.enterprises.microsoft.software.4.1.
1.2.1.19.6.116.120.95.102.115.109
          OID: 1.3.6.1.4.1.311.1.4.1.1.2.1.19.6.116.120.95.102.115.109
         Type: NULL
        Value: <No Data>


Does anyone know how to get around this?
Does anyone have a fix for this from Microsoft? I search Microsoft's
knowledge bases but there did not seem to be any bug submitted for this
behavior?
How do those of you that do monitor SQL server using SNMP, go about
doing it?

Please do let me know

Regards
Mohit

--
Unsubscribe mailto:mrtg-request at list.ee.ethz.ch?subject=unsubscribe
Archive     http://www.ee.ethz.ch/~slist/mrtg
FAQ         http://faq.mrtg.org    Homepage     http://www.mrtg.org
WebAdmin    http://www.ee.ethz.ch/~slist/lsg2.cgi