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

 

     Re: SQL Based Monitoring System

  • To: Jeremy Hinton <jgh at visi net>
  • Subject: Re: SQL Based Monitoring System
  • From: "Jonathan A. Zdziarski" <jonz at netrail net>
  • Date: Wed, 13 Oct 1999 16:04:14 -0400 (EDT)
rdbms's make great data warehousing applications.


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

Thank you,

Jonathan A. Zdziarski
Sr. Systems Administrator
Netrail, inc. 
888.NET.RAIL x240
http://www.netrail.net