Re: MSSql.MIB

--===============0854843503==
Content-Type: multipart/alternative;
boundary="----=_Part_28941_1667043.1206694231485"

------=_Part_28941_1667043.1206694231485
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,
I used the evntwin to generate traps and as a test , I configure it to send
me a trap if the sql server service manager is shut down , and it's go .
the only thing that I have still a doubt is that I should restart the
service snmp anytime I shut down the sql service in order to send me traps.


2008/3/27, snmp girl <snmp.girl@gmail.com>:
>
> what's about using the evntwin in windows , can it help instead of writing
> a programm?
>
> thanks
>
>
> 2008/3/27, Dave Shield <D.T.Shield@liverpool.ac.uk>:
> >
> > On 26/03/2008, snmp girl <snmp.girl@gmail.com> wrote:
> > > > OK - so what is the MIB object that reports the size of each
> > database?
> > >
> > > MIB : mssqlDbInfoSize
> > > OID: .1.3.6.1.4.1.311.1.4.1.1.6.1.5
> >
> >
> > The simplest approach is probably to write a little shell script
> > that does something like:
> >
> > fired=0
> > n=3 # the index of the Db row you wish to monitor.
> > while true
> > do
> > size=`snmpget -Ov .... mssqkIDbInfoSize.$n`
> > if [ $size -gt 6000 ]
> > then
> > if [ ! $fired ]
> > then
> > snmptrap .....
> > fired=1
> > fi
> > else
> > fired=0
> > fi
> > done
> >
> >
> > There is a way to handle this from within the agent itself
> > (see the section on "Active Monitoring" in snmpd.conf(5)),
> > but there are currently problems with monitoring data
> > from subagents.
> > I suspect the script above (suitably adapted for your needs)
> > may be the simplest in the short term
> >
> > Dave
> >
>
>

------=_Part_28941_1667043.1206694231485
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,</div>
<div>I used the evntwin to generate traps and as a test , I configure it to send me a trap if the sql server service manager is shut down , and it's go .</div>
<div>the only thing that I have still a doubt is that I should restart the service snmp anytime I shut down the sql service in order to send me traps.</div>
<div><br>&nbsp;</div>
<div><span class="gmail_quote">2008/3/27, snmp girl &lt;<a href="mailto:snmp.girl@gmail.com">snmp.girl@gmail. com</a>&gt;:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>what's about using the evntwin in windows , can it help instead of writing a programm?</div>
<div>&nbsp;</div>
<div>thanks<br><br>&nbsp;</div>
<div><span class="gmail_quote">2008/3/27, Dave Shield &lt;<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:D.T.Shield@liverpool.ac.uk" target="_blank">D.T.Shield@liverpool.ac.uk</a>&gt;:</span>
<div><span class="e" id="q_118ef93081a7952f_1">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On 26/03/2008, snmp girl &lt;<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:snmp.girl@gmail.com" target="_blank">snmp.girl@gmail.com</a>&gt; wrote:<br>
&gt; &gt; OK - so what is the MIB object that reports the size of each database?<br>&gt;<br>&gt; MIB : mssqlDbInfoSize<br>&gt; OID: .1.3.6.1.4.1.311.1.4.1.1.6.1.5<br><br><br>The simplest approach is probably to write a little shell script<br>
that does something like:<br><br>&nbsp;&nbsp; fired=0<br>&nbsp;&nbsp; n=3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;&nbs p;the index of the Db row you wish to monitor.<br>&nbsp;&nbsp; while true<br>&nbsp;&nbsp; do<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;size=`snmpget -Ov ....&nbsp;&nbsp;mssqkIDbInfoSize.$n`<br>&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if [ $size -gt 6000 ]<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;th en<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp; if [ ! $fired ]<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp; then<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp; snmptrap .....<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp; fired=1<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fi<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;else<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fired=0<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;&nbsp;fi<br>&nbsp;&nbsp;&nbsp;&nbsp;done<br><br >
<br>There is a way to handle this from within the agent itself<br>(see the section on &quot;Active Monitoring&quot; in snmpd.conf(5)),<br>but there are currently problems with monitoring data<br>from subagents.<br>&nbsp;&nbsp;I suspect the script above (suitably adapted for your needs)<br>
may be the simplest in the short term<br><br>Dave<br></blockquote></span></div></div><br></blockquote></div><br>

------=_Part_28941_1667043.1206694231485--


--===============0854843503==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216...et/marketplace
--===============0854843503==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Net-snmp-users mailing list
Net-snmp-users@lists.sourceforge.net
Please see the following page to unsubscribe or change other options:
https://lists.sourceforge.net/lists/...net-snmp-users

--===============0854843503==--