As part of most any database monitoring software evaluation, it includes comparing that software to similar solutions. Logically, it often means doing head-to-head comparisons to database tools that come bundled with that particular DBMS. Regularly, I see evaluators take note of similarities and differences of architecture, usability and navigation, and product features that present specific information to help address common use-cases. One of the more common scenarios is a DBA attempting to understand the value that Foglight for Oracle brings versus that of OEM – Oracle Enterprise Manager. During POCs (Proof of Concept), I sometimes encourage evaluators to consider Foglight for Oracle as a compliment to OEM rather than as a full replacement. Although Quest offers Oracle administration solutions, (like Toad), Foglight is intended as a monitoring and diagnostics solution. OEM is often best for many operational tasks not suited for Foglight. Foglight alerts users to potential performance issues and provides detailed metrics for diagnosis.
Here’s what a DBA team discovered when they participated in a detailed evaluation of Foglight.
4. Comparisons – “With Foglight, it is very easy.” You can compare…
- Dimension activity with different time ranges
- With a baseline of the same instance
- Another database instance
In OEM, you need to first generate AWR reports, then compare against a baseline or with another AWR report.
For more information, or to request a trial, visit the product page: Foglight database monitoring