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

"Burton Peltier" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message news:<46tTa.8171$h9.3763_at_fe04.atl2.webusenet.com>...
> --
> "Larry" <larry07_at_imap.cc> wrote in message
> news:93e49a46.0307222341.4a94e98f_at_posting.google.com...
> > lamimi02_at_aol.com (Lamimi02) wrote in message
> news:<20030722211020.10372.00000376_at_mb-m05.aol.com>...
> > > Are you using NFS by any chance? What's the CPU and memory configuration
> of the
> > > 10K box? I just don't think it is a good idea to put a data warehouse on
> NAS
> > > which is really not known for its performance. If your network bandwidth
> is
> > > saturated, it might not do any good to upgrade the SUN box.
> > >
> >
> > I suspect we are using NFS if the storage is in a NAS but I can't be
> > sure. Also to correct some information I provided before - the box is
> > a E4000 server, not a 10K
>
> We run a couple of E4000s that were upgraded to E4500s with the 400MHz chip.
> That is old equipment ... came out in something like 96.

yes one of the reasons for upgrading (ours has 6 CPU's I think)

>
> You may be good with just a V880 and 8 CPUs. We use the V880 for several
> database servers with great results with the Ultrasparc III and 750MHz on
> some and 900MHz others. We use local Sun T3 RAID arrays and you might be
> good with these too.

No we use NAS
>
> I am not familiar with pricing of a 12K , but I suspect it is at least 2 - 5
> times more expensive than a V880.

About 1.9X with 6 CPU's. But you can slot in up to 52(?) while the V880's are capped at 6 I think.

>
> >
> > > To choose between a 12K and RAC for data warehouse, I would pick 12K if
> your
> > > emphasis is performance. In general, both software and hardware are more
> > > expensive for RAC compared to non-RAC. You also have to maintain
> mulitple
> > > copies of the software and spend more time for setup. If you take those
> into
> > > account, they are not saving you money.
> > >
> >
> > Currently the load process is taking 90 hours(!) using a 6 way 400Mhz
> > processor going out over GBE to the NAS. Simple calculations (and
> > they are simple) suggest that going to a 12K with 6 UltraSparcIII
> > processors at 1.2G might improve that time 3fold? Of course now with
> > two GBE connections to the switching fabric, we might be moving the
> > problem from CPU to being IO bound?
> >
> > Also there is a fear that CPU usage will increase dramatically which
> > might be solved by adding more CPU's to the 12K but perhaps not solve
> > IO problems. On a RAC maybe we can add more servers?
> >
> > > If you are considering Linux/Intel, be aware of the 2G SGA size limit on
> 32-bit
> > > platforms. Putting a terabyte database on those systems can be a terror.
> >
> >
> > I was thinking of blade type Solaris machines like V280's
Received on Sat Jul 26 2003 - 06:39:33 CDT