Re: OEM vs Foglight
Date: Wed, 13 Jul 2011 14:41:24 -0700
Message-ID: <CADsdiQgB5gmsHnAv06eJXa=3QtQsxRRhSkuf-ujF0is_aHW_NQ_at_mail.gmail.com>
First, if you have the slightest interest in a desktop tool such as Spotlight I recommend DB Optimizer which I feel is much more powerful and modern. I'm biased as I worked on DB Optimizer at EMBT 2008-2010 but am no longer at EMBT thus can say with a clear conscious that DB Optimizer is awesome. I also worked at Quest on Spotlight. Spotlight was awesome 10 years ago when it came out but now outdated - it drives me crazy when it's the only tool customers have. I tried to modernize Spotlight immediately in 2001 <https://sites.google.com/site/youvisualize/active-session-history>when I worked at Quest. Quest wasn't interested and we quickly parted ways. I then went to Oracle in 2002 and worked on a complete redesign of the performance graphics, for example Top
Activity<https://sites.google.com/site/youvisualize/oem-10g-performance-pages---before-and-after>screen. I found Oracle frustratingly slow and bloated at times so I went to Embarcadero to work on a smaller faster product DB Optimizer. DB Optimizer was a challenge as it had to work on not only Oracle but DB2, SQL Server and Sybase in the same interface but it takes performance monitoring even farther, runs faster and is a sinch to install. I think it came out awesome not to mention the Visual SQL
Tuning<http://dboptimizer.com/2011/07/08/woohoo-vst-takes-the-next-step/>stuff. DB Optimizer is primarily a desktop tool. DB Optimizer can be made to collect into a shared repository 24x7 but that isn't it's forte. The realm of 24x7 mutli-target monitoring is the forte of Enterprise tools.
Enterprise tools for databases are either OEM, Foglight, Confio or Indepth. Of these OEM and Foglight seem like the best. I've never used Foglight but from the demo's I've seen on Quest's website it looks good and looks like they understand the domain and have designed well for it. The biggest obstacle I've heard is that Quest requires a binary to run on each target and the binary depends on OS type, OS version and Oracle version so it can be quite a management challenge. Quest bought Foglight back in 2001 time frame and was basically boondoggled AFAIU. Quest then invested enormous resources to structure Foglight into something usable. How far they have come I don't know. The part I like is the Quest Performance Analyzer for Oracle. Quest had cool videos on Perf Analyzer for Oracle online but I can't find them anymore - strange.
I don't think there is a perfect enterprise Oracle monitoring solution. OEM is nice - of course I like things which makes sense as I design parts, but other parts drive me crazy and all parts tend to be slow and granular and the framework is bloated. If I were a customer I'd definitely want to do a trial run with Foglight on my systems.
Unfortunately the enterprise monitoring space is drying up and companies like Quest and Embarcadero are cutting development resources back to a minimum. Just found this link that echos this sentimentshttp://www.infoworld.com/d/data-management/can-quest-foglight-hang-big-boys-601from 5 years ago (take the comments about Foglight with a grain of salt as the article is old)
The lack of decent tools to manage your databases on an enterprise level is
> just staggering. It's hard to believe that nobody can cross the finish line
> on delivering a monitoring solution.
>
I would love to create a better enterprise solution if I could find the funding! :)
On Wed, Jul 13, 2011 at 8:01 AM, <Joel.Patterson_at_crowley.com> wrote:
> IMHO,****
>
> ** **
>
> OEM is “oracle’s”, so my analogy goes something like this: Its like
> gravity; you can’t resist, and oracle will put more a more into OEM sooner
> or later – akin to Microsoft. (eg. You wanted to use WordPerfect and
> Lotus123, but in the end there was only so much you can invest, and…
> eventually caved under the weight created by Microsoft. That most people
> do not wish to learn multiple programs, and thus it turns out that everyone
> else uses Word and Excel – ipso facto, doesn’t matter if one is better than
> another, Microsoft floated to the top). I think that eventually, like
> this analogy, oracle is going to make it a reality somehow that you want or
> wish you had OEM in house.****
>
> ** **
>
> So, to continue, since Foglight for oracle is not cheap, having both is not
> practical. Spend some extra money on DBOptimizer to go with the
> monitoring tool.****
>
> ** **
>
> ** **
>
> Joel Patterson
> Database Administrator
> 904 727-2546 ****
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Guillermo Alan Bort
> *Sent:* Wednesday, July 13, 2011 10:36 AM
> *To:* oracle-l-freelists
> *Subject:* OEM vs Foglight****
>
> ** **
>
> So, today we had a very boring and long presentation by Quest about
> foglight... I must admit I spaced out 10 minutes in, so I honestly don't
> know what they are offering... they are saying that their product is the
> best and I think it's a lot cheaper that OEM... so my question goes out
> there to you, the community whose opinion I respect. If you had the choice
> of staying with OEM or implementing foglight, what would you do? why?
>
> my curiosity tells me to go with spotlight just because it's something I
> don't know... and I like to challenge myself... my lazy side is telling me
> to stick with OEM which I know how to break and sometimes even how to fix...
>
>
> My obsessive side is gathering all the information it can to make an
> informed recommendation to management... so... here I am.
>
> Thanks in advance
> Alan.-****
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 13 2011 - 16:41:24 CDT