Re: Capacity Planning for 8i on W2K

Thanks for the reply.

I have no control over third party code. Not much I can do about that.

Will monitor I/O better.

Thanks...

"Fred A G" <nospam_at_allowed.localhost> wrote in message news:0guj6.2320$hi2.6771_at_nntpserver.swip.net...
>
> "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 - 22:45:48 CST