Re: Capacity Planning for 8i on W2K

"Ford Prefect" <rcolebeckXXX_at_home.com> wrote in message news:X6kj6.22223$HG.5226949_at_news4.rdc1.on.home.com...
> We will be upgrading our 7.3.4 to 8i this year to a W2K install.
> We are running it on a single CPU PII 400 1GB RAM NT4
 

> It has SCSI drives (no RAID) only 40Mb transfer rate.
>

How many drives?

Don't stare too hard at the interface theoretical max (bus bandwidth), instead investigate how much IO/s you need. Also, storage capacity can sometimes be misleading, i.e. don't get one 72GB drive, instead get 8 9GB drives. The 15krpm drives give quite nice IOPS (near 160 when IO size below 16KByte).

> This server serves 15 heavy users and another 25 light users.
> Performance definitely degrades if a big query or report is being run.
> To the point users notice and complain!
>

Taking care of bad/heavy reports, i.e. tuning application code, can give the best upgrade in performance. (We fixed one very heavy hitting report simply by doing a small change to the underlying query.)

> I'm trying to recommend a hardware config that will suit 8i and give
 us the
> perfomance results desired.
>
> Anyone with experience like to suggest some minimums?
>

Experience with what application? What are the desired performance results?

I hope nobody tries to give you a hardware purchasing advice based on only database software version!

Regards
/Fad

> Thanks...
>
> --
> Richard Colebeck
>
>
Received on Sat Feb 17 2001 - 06:38:13 CST