Re: Capacity Planning for 8i on W2K

Well get dual cpu's I run 8i on a 700mhz with 512mb ram and it can slow down to almost a stand still(no other apps running) when using OEM. Either that or avoid using OEM or any other memory intensive applications. "Ford Prefect" <rcolebeckXXX_at_home.com> wrote in message news:0sIj6.28796$HG.7108214_at_news4.rdc1.on.home.com...
> 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 Sun Feb 18 2001 - 20:51:26 CST