Re: database monitoring tools - splunk?

  • From: David Robillard <david.robillard@xxxxxxxxx>
  • To: Robert G Stauffer <rstauffer@xxxxxxxxxxxxxxxxxxxx>
  • Date: Mon, 28 Feb 2011 09:11:22 -0500

Hi Robert,

We leverage Nagios, Net-SNMP and several Nagios plugins to monitor our
network of Linux, FreeBSD, AIX, Solaris, ESX and Windows hosts plus
our MySQL, PostgreSQL, Oracle and SQL Server databases. We also use
the same Nagios setup to monitor our Cisco and APC equipements and a
whole bunch of other software such as Tomcat, JBoss, sendmail, BIND,
etc.

Take a look at this thread on the same subject:

//www.freelists.org/post/oracle-l/Monitoring-software,10
//www.freelists.org/post/oracle-l/Monitoring-software,19

> On a slightly different tack, has anyone used or investigated splunk
> (splunk.com)?  It looks versatile and interesting but I haven't had much
> chance to check it out.

We had a demo from the Splunk guys here at work and it looks very
interesting. A member of my team has then started using the free
version of Splunk just to see if it was worth the investment. The
first thing that came out is that very steep learning curve. The tool
is very powerful, but in order to harness this power, one must learn
how to use it. And this can prove challenging. But IMHO it's worh it.

HTH,

David

> We've looked at OEM numerous times over the years but have found it to
> be more of a maintenance headache than it's worth.  At the moment, we do
> most of our Oracle db monitoring with custom korn shell and Windows
> shell scripts.  I'm considering using the following tools to monitor our
> numerous, disparate systems - Oracle, SQL Server, MySQL on Linux,
> Solaris, AIX, and Windows:
>
> - server/os monitoring: zenoss (our system admins are currently using
> this)
> - db process monitoring/maintenance from a dba maintenance server:
> remote perl scripts
> (http://mirror.facebook.com/cpan/authors/id/S/SA/SALVA/sperl-1.00)(?)
> - db monitoring/maintenance from a dba maintenance server: db command
> line utility (sqlplus, etc.)
> - log monitoring from a dba maintenance server: splunk
>
>
>
> Bob Stauffer
> DBA
> D&E Communications
> Ephrata, PA
> rstauffer@xxxxxxxxxxxxxxxxxxxx
> 717-738-8737
--
//www.freelists.org/webpage/oracle-l


Other related posts: