[mrtg] Re: Monitoring SQL

Paul C. Williamson pwilliamson at MANDTBANK.COM
Mon Feb 12 21:22:40 MET 2001


What box are you doing the querying from?  From most *nix variants,
you can use snmpget x.x.x.x community OID and you'll get a value back.
Or you can do an snmpwalk x.x.x.x community > textfile, open the text file
and look for the mib you want to query.

Paul

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

Using what tool? Getif is the only mib browser I currently know how to use.
Any suggestions?

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


Can you do this query from the command line vs. GETIF?

>>> Adrian Mink <Adrian.Mink at fidata.com> 02/12/01 11:10AM >>>

Could someone please take a look and help me out? This problem has got me
stumped.

Adrian

-----Original Message-----
From: Adrian Mink [mailto:akmink at austin.rr.com] 
Sent: Sunday, February 11, 2001 1:13 AM
To: Mrtg
Subject: [mrtg] Monitoring SQL



I am trying to setup monitoring of page reads and writes on a SQL server
through MRTG and am having some issues.
When I check the OID for page reads and writes using Getif I get the correct
response, but when I try using mrtg I get
an error. Here is my config file and the error message. I am at a loss, I
hope someone can give me a clue.


####################################################################
# 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
Target[SITESERVER]:
1.3.6.1.4.1.311.1.4.1.1.2.1.4&1.3.6.1.4.1.311.1.4.1.1.2.1
.5: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:


And here is the error message:

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.4)
SNMPv1_Session (remote host: "192.168.35.27" [192.168.35.27].161)
                  community: "public"
                 request ID: 139858313
                PDU bufsize: 8000 bytes
                    timeout: 2s
                    retries: 5
                    backoff: 1)
SNMPGET Problem for 1.3.6.1.4.1.311.1.4.1.1.2.1.4
1.3.6.1.4.1.311.1.4.1.1.2.1.5
on public at 192.168.35.27 



Again, this does return valid data using Getif! Help!! Thanks.

Adrian


--
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