RE: database monitoring tools - splunk?
- From: "Stauffer, Robert G" <rstauffer@xxxxxxxxxxxxxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Apr 2009 10:53:06 -0400
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'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
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse
Sent: Thursday, April 02, 2009 10:20
To: 'Oracle-L Freelists'
Subject: Re: database monitoring tools - what is your short list of
requirements?
> Simple Customization - DBAs know sql and pl/sql. Have the ability to
add
> custom monitoring/alerts using the language of the database...not tcl,
> not perl (sorry Jared), not java. It would be handy to set alerting
> thresholds based on return values (<10, 10 - 100, 101 - 1000, >1000).
Interesting -- I don't think I'd like to rely solely on a product to
monitor
itself. If it should fail, so would the monitor and any notification I
would expect from it.
Perl, OTOH, can be installed as part of the Oracle software. And it was
surprisingly easy to make my script platform agnostic, even with regard
to
filesystems.
Simplicity and stability are two qualities I should have mentioned in a
monitoring tool.
My $.02,
Rich
--
//www.freelists.org/webpage/oracle-l
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use
of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the message
or any information contained in the message. If you have received this
communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the extent
that it relates to their official business.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
