[mrtg] Re: Monitoring SQL

James Furnish jfurnish at firstam.com
Tue Feb 13 01:19:14 MET 2001


I have noticed when I first install the snmp4nt
http://www.wtcs.org/snmp4tpc/default.htm I have to use getif and walk the
memory oid at least twice before it starts returning values.  Its worth a
shot anyway.

-----Original Message-----
From: mrtg-bounce at list.ee.ethz.ch [mailto:mrtg-bounce at list.ee.ethz.ch]On
Behalf Of Adrian Mink
Sent: Monday, February 12, 2001 2:08 PM
To: Mrtg (E-mail)
Subject: [mrtg] Re: Monitoring SQL



Sorry, the mrtg box is RedHat Linux 6.1.

-----Original Message-----
From: Paul C. Williamson [mailto:pwilliamson at MANDTBANK.COM]
Sent: Monday, February 12, 2001 4:06 PM
To: Adrian.Mink at fidata.com
Subject: [mrtg] Re: Monitoring SQL


Is your MRTG box windows or something else?   I still haven't seen that
answer....

>>> Adrian Mink <Adrian.Mink at fidata.com> 02/12/01 04:59PM >>>

That is what is killing me, I can use Getif to query that value on the
correct
system! I just cannot query that same value from the mrtg box! I can query
the standard
OID's without a problem, just not the OID's for SQL. But again, I can query
the SQL OID's
on that box from my own workstation. What little hair I have left is falling
out in
droves.... Thanks...

Adrian

-----Original Message-----
From: Paul C. Williamson [mailto:pwilliamson at MANDTBANK.COM]
Sent: Monday, February 12, 2001 3:54 PM
To: Adrian.Mink at fidata.com
Subject: [mrtg] Re: Monitoring SQL


Loading the MIB into MRTG won't do anything for you if the MIB isn't on
the system you want to query.  You mentioned that you can query that OID
on another system with GETIF, but not the one in question?  Sounds
like the MIB isn't on the box you want to monitor.  You can load
GETIF on a Windoze box and query any device (server, router, etc.)
with an IP address and community name.  Have you tried that?

Paul


>>> Adrian Mink <Adrian.Mink at fidata.com> 02/12/01 04:41PM >>>

I tried adding the trailing zeros, I have also loaded the mib file for MSSQL
using the loadmib
directive. Here is a copy of the config I am using again. I am still getting
the "nosuchname" snmp error. If I understand the loadmib directive, you need
one statement per OID? Even if the two values are contained in the same mib
file? Thanks.


####################################################################
# MRTG CONFIG FILE - SQL INFORMATION
# SERVER: SiteServer
####################################################################

Title[^]: Page Reads and Writes on SQL Server on Siteserver:
PageTop[SITESERVER]: <div align="center"><center>

 <table border="1" width="98%" height="87">
  <tr>
    <td width="76%" height="52"><p align="center"><strong><font
face="Arial"><big>Page Reads   and Writes on SQL on
&quot;SITESERVER&quot;</big></font></strong></td>
    </tr>
  <tr>
    </tr>
 </table>
 </center></div>

NoMib2: Yes
LoadMIBs:
/usr/local/mrtg-2.9.7/mib/MSSQL.MIB,/usr/local/mrtg-2.9.7/mib/MSSQL.MIB
Target[SITESERVER]:1.3.6.1.4.1.311.1.4.1.1.2.1.4.0&
1.3.6.1.4.1.311.1.4.1.1.2.1.5.0:public at 192.168.35.27
MaxBytes[SITESERVER]: 1000
WithPeak[SITESERVER]: ymd
Title[SITESERVER]: SQL on Siteserver
Options[SITESERVER]: gauge, nopercent, growright
Unscaled[SITESERVER]: dwmy
#Supress[SITESERVER]:dwmy
XSize[SITESERVER]: 380
YSize[SITESERVER]: 100
YLegend[SITESERVER]: Page Reads and Writes
ShortLegend[SITESERVER]: Reads/Writes
Legend1[SITESERVER]: Page Reads
Legend2[SITESERVER]: Page Writes
Legend3[SITESERVER]: Maximal 5 Minute Reads
Legend4[SITESERVER]: Maximal 5 Minute Writes
LegendI[SITESERVER]: Reads:
LegendO[SITESERVER]: Writes:

-----Original Message-----
From: cpt2 at daimlerchrysler.com [mailto:cpt2 at daimlerchrysler.com]
Sent: Monday, February 12, 2001 3:01 PM
To: mrtg at list.ee.ethz.ch
Subject: Re: [mrtg] Re: Monitoring SQL





Sent by:  mrtg-bounce at list.ee.ethz.ch


To:   "Mrtg (E-mail)" <mrtg at list.ee.ethz.ch>
cc:
Subject:  [mrtg] Re: Monitoring SQL


Adrian, try adding a trailing 0 to the to OIDs like this:

Target[SITESERVER]:1.3.6.1.4.1.311.1.4.1.1.2.1.4.0&1.3.6.1.4.1.311.1.4.1.1.2
.1

.5.0:public at 192.168.35.27



OK, doing a snmpwalk of the system and I do not see the value I want to
query. But I can query it with getif from a different system and get the
response. I did not see anything in the MRTG docs about having to compile
in
MIB's, do you have to? (Since this is not a standard value I am accessing.)
I did have to for getif. Thanks for you patience, this is driving me up a
wall.

-----Original Message-----
From: Paul C. Williamson [mailto:pwilliamson at MANDTBANK.COM]
Sent: Monday, February 12, 2001 2:23 PM
To: Adrian.Mink at fidata.com; mrtg at list.ee.ethz.ch
Subject: [mrtg] Re: Monitoring SQL



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


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

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




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



More information about the mrtg mailing list