Re: DBA Monitoring Tools

In article <303h4n$93_at_news.cc.oberlin.edu>, Alan Schafer <bschafer_at_ocvaxc.cc.oberlin.edu> writes:

If you are interested in event monitoring, space management or configuration managment, I would recommend EcoTools by Compuware. The product does virtually everything DBVision does and much more.

EcoTools will enable you to manage your distributed environment by monitoring the database, the machine it's running on as well as the network. DBVision currently only looks at the database. A major shortcoming that they will address in future releases.

Event agents will help you receive notification of problems based on user defined thresholds. Data agents will help you build a performance baseline and predict future space requirements.

The tool has a GUI front-end and currently supports SunOS, Solaris, AIX, HPUX, Sequent, SCO and Pyramid.

EcoTools can monitor and report information on the amount of cpu used, io reads and writes, network traffic, locks held, blocking locks, completed transactions per database, ...

One of the strengths of the tool is that agents connecting the database can be joined together with agents at the OS and network level using boolean
logic. For instance, an agent checking the status of a database could also
check the network, if the server appears to be down due to a network outage,
the network administrator could be notified directly, rather alerting the DBA
who will then have to investigate and call the person responsible for the network.

Finally, action programs can also be associated with event agents, allowing
you the ability to automatically perform corrective actions. For instance,
if archive log file is found to be full, you could have an action program log into the server, dump the log and send email notification of the event and the action taken. I don't believe DBVision has this automated corrective actions capability.

DBVision has supposedly only 10 alarm functions and 75 other scanners. EcoTools has over 200 agents right out of the box.

You can get further information on EcoTools by contacting Compuware at 800-521-9353. Received on Thu Jul 21 1994 - 05:20:08 CEST