Re: SAME methodology opinions?

Hello!

Simple, I keep hearing this too much, that adding more cache, memory, CPU is all you need and forget about planning your IS/DB/HW. And I just talked to a Hitachi salesman few weeks ago, that told me the same story.. especially with the one that EMC can't handle IO at all, etc..

I'm not against the SAME methodology at all - it can help to lower the administration costs of small to medium databases with small performance impact. Of course, if one doesn't/can't plan a physical database structure properly, SAME would be a safe bet. But if you do have a little common sense and understanding of RDBMS'es, you can achieve better results with separate disks. The question is, which is more expensive, DBA knowledge for planning or hardware (software/licenses).

But what I'm strongly against, is the idea that cache is the cure for all worlds problems, e.g. if your DB gets slow, just get more cache (or even buy CPUs). As long as you don't cache every single bit of your data, the disks will always be a bottleneck.

Tanel.

> > Seems that you are a novice salesman at Hitachi?
> >
> >
> > Definitely a Hitachi salesman.
> >
> >
> > The situation is getting more and more extreme. Every day.
> >
>
>
> Care to elaborate and share your insight ?
Received on Tue Mar 11 2003 - 08:04:00 CST