[mrtg] Re: Monitoring SQL

Adrian Mink Adrian.Mink at fidata.com
Mon Feb 12 22:59:08 MET 2001


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



More information about the mrtg mailing list