Re: Upgrade to big SUN box or RAC for data warehouse?

"dick" <dick_at_dick.com> wrote in message news:<O8bTa.44894$PD3.4478203_at_nnrp1.uunet.ca>...
> Take a look at TeraData product from NCR.
>
> RAC may provide small increases in performance. If you need huge increases
> then you likely need a diferent solution. We are currently an Oracle shop,
> but are investigating TeraData for 1 specific problem.
>

Thanks for the responses. I probably should have been more detailed.

1. The box we have is apparently going out of service which is a driver
2. We need to go to 9i for audit purposes
3. While the load is exceeding SLA's there are some queries which are taking longer than we want.

As I said the load times I think are related to IO - traffic from the 10K box IO subsystem to the NAS (GBE) is probably a limiting factor.

A new box like a 12K would have better a better IO system, more paths to the NAS and be faster (Sparc III at 1.2G versus Sparc II chips at 400Mhz). I am just not convinced that this is the only solution. A bunch of V480's using dual Sparc III chips each with their own access to the NAS could be equally fast and much cheaper. And of course we could even go Intel/Linux to really save money

Just want to beyond the vendor hype (Sun who want to sell a big box to us) and Oracle who say RAC is the best thing since sliced bread

Larry Received on Tue Jul 22 2003 - 15:39:37 CDT