[Date Prev]   [Date Next] [Thread Prev]   [Thread Next] [Date Index]   [Thread Index]


     Re: SQL Based Monitoring System

On Wed, 13 Oct 1999, Vikas Aggarwal wrote:
> On Wed, Oct 13, 1999 at 11:05:21AM -0400, Jonathan A. Zdziarski wrote:
> > > Think about this... what if...
> > >
> > > NetSaint, or NOCOL, or whatever monitoring package you used... was
> > > converted to store ALL events in SQL.  Rather than having an 'event
> > > status' variable for each event with one single variable, you have
> > > multiple events in the database for the same host, same service....
> Do you all mean the 'events' that are currently in the data/ directory or
> do you mean the 'noclogd' logs which only log 'state' changes? I think
> only the state changes would be useful in a database.

I disagree. If your goal is purely from a monitoring perspective maybe,
but what about historical trending of non-event trigerring data? Most
folks are probably interested in this as well (look at how big MRTG is),
and why gather the same data twice? True, though, most of your queries for
this sort of data would be purely sequential, restricted on date/time.

- jeremy

Jeremy Hinton                      Yes, Rabbit has Brain.
jgh@visi.net                 I suppose thats why he never
www.visi.net/~jgh                   understands anything.
NOC - VisiNet                          -- Winnie the Pooh