SQL SNMP Problems
Joshua Andrews
I've been trying to get SNMP monitoring working properly on SQL Server
2000 on Windows Server 2003. Unfortunately, I didn't install SNMP until
after I had installed SQL Server.
I have, however, followed the instructions regarding copying over and
registering the sqlsnmp.dll file and adding the appropriate entries to
the registry. I've also installed the excellent snmp-informant software
and am using it to monitor disk, cpu, and network activity, etc. SQL
Server reports when it starts that the SNMP Agent Extension is loading.
The only problem is when I attempt to directly query anything, I get no
response. MRTG tells me:
D:\Program Files\mrtg\bin>perl mrtg sqldata.cfg
SNMP Error:
Received SNMP response with error code
error status: noSuchName
index 1 (OID: 1.3.6.1.4.1.311.1.4.1.1.2.1.3.4.83.81.76.50)
SNMPv1_Session (remote host: "sql2.ourcompany.com" [10.100.20.55].161)
community: "kccsecret"
request ID: 1044051197
PDU bufsize: 8000 bytes
timeout: 2s
retries: 5
backoff: 1)
at D:/Program Files/mrtg/bin\..\lib\mrtg2/SNMP_util.pm line 490
SNMPGET Problem for .1.3.6.1.4.1.311.1.4.1.1.2.1.3.4.83.81.76.50
.1.3.6.1.4.1.31
1.1.4.1.1.2.1.3.4.83.81.76.50 sysUptime sysName on
kccs...@sql2.kccllc.com::::
::v4only
at mrtg line 1846
ERROR: Target[sql2_proc][_IN_] ' $target->[0]{$mode} ' did not eval into
defined
data
ERROR: Target[sql2_proc][_OUT_] ' $target->[0]{$mode} ' did not eval
into define
d data
I can do a getnext from within other SNMP utilities, but doing a direct
get yields no results.
Anyone have any suggestions?
Thanks,
Josh