Re: Capacity Planning for 8i on W2K

Today I was testing OEM 2.2. on an 8.1.6 repository on a single-CPU NT4SP5 test server with roughly 390M of RAM. The only connections are mine: OEM console, and SQL*Plus from the desktop. No user sessions at all.

The memory utilisation climbs to 360M, and never goes above that. NT refuse to load anything above that, even though there is 1G of virtual memory available. The Oracle tools require RAM, not virtual memory. Instead of climbing above 360M of memory, applications just refuse to start. Funny things start to happen.

I am still testing.

The java-based OEM tools gobble memory like crazy; DBA Studio alone used up 18M of RAM for the connection. I am more used to seeing 2-8M of memory per session on my Tru64 UNIX server.

I convinced management to order me another 256M of RAM. This is a P-III test server, perhaps to become an OEM repository. After the additional 256M of RAM if I still have problems we will have to upgrade the machine, no doubt about it.

Regards,
Patrice Boivin
Halifax, Canada.

dgdss wrote:
>
> 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 Mon Mar 05 2001 - 19:00:43 CST