Monitoring MS SQL using SNMP

Monitoring MS SQL using SNMP

Post by Jag Ma » Sun, 17 Jun 2001 10:57:12



I am having trouble running snmpget against mssql.mib oids.
All oids having problem.  However snmpwalk works OK!

# snmpwalk MSSQL01 public .1.3.6.1.4.1.311.1.4.1.1.2.1.4.11
enterprises.311.1.4.1.1.2.1.4.11.67.69.82.84.80.65.84.82.79.76.49 =
Counter32: 296
# snmpget MSSQL01 public
enterprises.311.1.4.1.1.2.1.4.11.67.69.82.84.80.65.84.82.79.76.49
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
Failed object:
enterprises.311.1.4.1.1.2.1.4.11.67.69.82.84.80.65.84.82.79.76.49

I tried 67.69.82.84.80.65.84.82.79.76.49 to convert this string from Hex to
Dec but it didn't work.  I needs to run this counter against mrtg for
graphs.

Please post your suggestions!!!

TIA!
Manny

 
 
 

1. snmp monitoring of MS Sql Server 6.5?

I wish to monitor user connections and a few other things with MRTG,
SNMP and the SNMPmib that comes with SQL Server 6.5.  HOWEVER, everytime
I query the OID:

.1.3.6.1.4.1.311.1.4.1.1.2.1.16

I get:
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
This name doesn't exist: enterprises.311.1.4.1.1.2.1.16

yet, this is the OID that specifies number of connections active to sql
server when you look in Microsoft's mib definition file....  It only
gets better....  if I snmpwalk the same OID I get:


.1.3.6.1.4.1.311.1.4.1.1.2.1.16
enterprises.311.1.4.1.1.2.1.16.8.82.78.68.66.69.84.72.50 = Gauge: 10

which would tell me that I can query
.1.3.6.1.4.1.311.1.4.1.1.2.1.16.8.82.78.68.66.69.84.72.50, right?
Wrong.  If I query that I get:


.1.3.6.1.4.1.311.1.4.1.1.2.1.16.8.82.78.68.66.69.84.72.50
Error in packet
Reason: (noSuchName) There is no such variable name in this MIB.
This name doesn't exist:
enterprises.311.1.4.1.1.2.1.16.8.82.78.68.66.69.84.72.50

Am I going crazy??  Has anyone been able to snmpget ANY OID's from the
mssql snmp agent??

Thanks in advance,
Jay Colson

2. Selecting a Mail Profile for SQL Mail

3. Monitoring Sybase using SNMP?

4. Licensing/Limiting access to a VB program

5. monitoring many machines using snmp & syslog

6. Error return while creating index by Pervasive.SQL 2000

7. Monitoring SQL 2000 w/ SNMP

8. US-WA-OR-ID-Oracle Financials/Manufacturing/Human Resources Technical & Functional Implementors Wanted

9. SQL MIBS for SNMP monitoring

10. Monitor SQL Server Memory Usage Using NT Performance Monitor

11. SNMP Traps with in MS SQL Server 2000

12. MS-SQL and SNMP

13. SNMP management of MS-SQL