[mrtg] Re: MSSQL Server and MRTG

[Tendolkar Mohit]

This is a well known problem with the MS SQL server agent.

People have been asking this question (including me!) since about 1998.

Microsoft disregarded it and recently we filed a service request with MS.

MS looked into it, verified it was a bug and claimed that they would NOT fix this behavior and WMI/WBEM was the way to SQL server would support monitoring in the future.
They said they would file a KB for it, I don't know if they have.
I have a feeling that Microsoft is slowly but steadily moving away from SNMP indicating SNMP's feeling security support as a prime reason.

GETNEXT by definition is a "lexicographic NEXT" object, so I do not think it is the correct way to perform "polling" for a specific object instance.

MRTG allows defining custom scripts to allow using some other data acquisition mechanism (other than SNMP). 

Maybe you should write some perl script/vbscript etc that could poll the WMI object rather than the SNMP object. Maybe someone out there could share such a script to users like us....

Regards
Mohit

-----Original Message-----
From: mrtg-bounce at list.ee.ethz.ch [mailto:mrtg-bounce at list.ee.ethz.ch] On Behalf Of Patrick Noël
Sent: Friday, April 22, 2005 5:21 AM
To: mrtg at list.ee.ethz.ch
Subject: [mrtg] MSSQL Server and MRTG

Hi

I try to use MRTG for monitoring MSSQL Server.  For example I want to create a graph for the counter "userblocked"

when i use snmpwalk i have :

 snmpwalk -m /usr/share/snmp/mibs/MSSQL-MIB.txt sql-server .1.3.6.1.4.1.311.1.4.1.1.2.1.19 enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoUsersBlocked."SQL_SERVER" = Gauge32: 6

or snmpgetnext

 snmpgetnext -m /usr/share/snmp/mibs/MSSQL-MIB.txt sql-server .1.3.6.1.4.1.311.1.4.1.1.2.1.19 enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoUsersBlocked."SQL_SERVER" = Gauge32: 14

but with snmpget 

 snmpget -m /usr/share/snmp/mibs/MSSQL-MIB.txt sql-server .1.3.6.1.4.1.311.1.4.1.1.2.1.19 Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: enterprises.microsoft.software.apps.mssqlServer.mssqlServerObjects.mssqlSrvInfoTable.mssqlSrvInfoEntry.mssqlSrvInfoUsersBlocked

snmpgetnext  sql-argus .1.3.6.1.4.1.311.1.4.1.1.2.1.19
enterprises.311.1.4.1.1.2.1.19.9.83.81.76.95.65.82.71.85.83 = Gauge32: 8


i try with :

snmpget  sql-argus .1.3.6.1.4.1.311.1.4.1.1.2.1.19.9.83.81.76.95.65.82.71.85.83
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object: enterprises.311.1.4.1.1.2.1.19.9.83.81.76.95.65.82.71.85.83

have an idea so that it reason snmpget does not work ?

how to use snmpgetnext instead of snmpget in MRTG ?

thanks

Patrick

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



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