Re: MSSql.MIB

"Dave Shield" <[email protected]>
Newsgroups gmane.network.net-snmp.user
Message-ID <[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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.