[mrtg] Monitoring SQL server

Tendolkar Mohit Mohit.Tendolkar at thomson.net
Wed Feb 2 23:00:38 MET 2005


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 .

SnmpTool - Simple Network Management Protocol Tool for Win32

Performing branch walk starting at OID

         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 .

SnmpTool - Simple Network Management Protocol Tool for Win32

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

    varbind 1:
         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
How do those of you that do monitor SQL server using SNMP, go about
doing it?

Please do let me know


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

More information about the mrtg mailing list