Re: database monitoring tools - splunk?

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:

http://www.freelists.org/post/oracle-l/Monitoring-software,10 http://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_at_decommunications.com
> 717-738-8737

--
http://www.freelists.org/webpage/oracle-l