--
"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.
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.
I am not familiar with pricing of a 12K , but I suspect it is at least 2 - 5
times more expensive than a V880.
>
> > 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 Wed Jul 23 2003 - 05:18:53 CDT
