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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patrick Noël Sent: Friday, April 22, 2005 5:21 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] 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
