Re: MSSql.MIB

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 <[email protected]>:
>
> what's about using the evntwin in windows , can it help instead of writing
> a programm?
>
> thanks
>
>
> 2008/3/27, Dave Shield <[email protected]>:
> >
> > On 26/03/2008, snmp girl <[email protected]> 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
> >
>
>

-------------------------------------------------------------------------
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;164216239;13503038;w?http://sf.net/marketplace

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