sql snmp extension with clustered servers

sql snmp extension with clustered servers

Post by Chris Heidbrin » Sat, 18 Jan 2003 00:08:20



Hi, I am having problems querying the sql portion of the
microsoft snmp mib on clustered servers.  Whenever I query
any portion of the sql mib tree other than the first octet
it crashes snmp for a minute or two and no information for
that portion of the mib is returned.

so, only sql beginning portion of mib (works):
snmpwalk ndp101 public .1.3.6.1.4.1.311.1.4.1.1
enterprises.311.1.4.1.1.1.1.1.21.77.105.99.114.111.115.111.
102.116.32.67.111.114.112.111.114.97.116.105.111.110
= "Microsoft Corporation"
enterprises.311.1.4.1.1.1.1.2.21.77.105.99.114.111.115.111.
102.116.32.67.111.114.112.111.114.97.116.105.111.110 = "MS
SQL Server"
enterprises.311.1.4.1.1.1.1.3.21.77.105.99.114.111.115.111.
102.116.32.67.111.114.112.111.114.97.116.105.111.110
= "8.00.194"

portion of sql mib that returns db names (doesn't work):
snmpwalk ndp101 public .1.3.6.1.4.1.311.1.4.1.1.6.1.2
Timeout: No Response from exndp101

This then crashes snmp all together for a minute or two
and this log is logged in the event viewer:

"MS SQL SNMP Extension Agent reconnecting".

On boxes that are just standalone sql server all of the
sql extension oids work correctly.  Any help would be
greatly appreciated.

Thanks,

Chris

 
 
 

1. sql snmp extension with clustered servers

(sorry for the cross-post (to sqlserver.server also))

Hi, I am having problems querying the sql portion of the
microsoft snmp mib on clustered servers.  Whenever I query
any portion of the sql mib tree other than the first octet
it crashes snmp for a minute or two and no information for
that portion of the mib is returned.

so, only sql beginning portion of mib (works):
snmpwalk ndp101 public .1.3.6.1.4.1.311.1.4.1.1
enterprises.311.1.4.1.1.1.1.1.21.77.105.99.114.111.115.111.
102.116.32.67.111.114.112.111.114.97.116.105.111.110
= "Microsoft Corporation"
enterprises.311.1.4.1.1.1.1.2.21.77.105.99.114.111.115.111.
102.116.32.67.111.114.112.111.114.97.116.105.111.110 = "MS
SQL Server"
enterprises.311.1.4.1.1.1.1.3.21.77.105.99.114.111.115.111.
102.116.32.67.111.114.112.111.114.97.116.105.111.110
= "8.00.194"

portion of sql mib that returns db names (doesn't work):
snmpwalk ndp101 public .1.3.6.1.4.1.311.1.4.1.1.6.1.2
Timeout: No Response from exndp101

This then crashes snmp all together for a minute or two
and this log is logged in the event viewer:

"MS SQL SNMP Extension Agent reconnecting".

On boxes that are just standalone sql server all of the
sql extension oids work correctly.  Any help would be
greatly appreciated.

Thanks,

Chris

2. Any good shareware library systems?

3. Performance Monitor Extension DLL on SQL Server Cluster

4. Adding background wallpaper to form?

5. SNMP extensions for Online 7.11UC1

6. MY SQL SERVER IS DEAD!!!! PLEASE HELP!!!!!

7. SNMP Extension Agent

8. Migrationto 8.0.6

9. After the SQL cluster upgrade to cluster, the SQL server cannot be accessed

10. SQL Server 2000 & Office Server Extensions

11. SQL Server 7.0 Cluster ressources don′t showup in Cluster Administration

12. Oracle snmp and HPUX snmp problem

13. Setup SNMP Agent (snmp.ora)