[Date Prev] [Date Next] | [Thread Prev] [Thread Next] | [Date Index] [Thread Index] |
Re: SQL Based Monitoring System
|
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 |