Re: Performance problem

Gerrit-Jan Linker wrote:

> I experienced something similar.
>
> It was on a PIII with loads of memory (1GB I believe) and just Oracle
> running. Our mistake was that we let a few VB programs run on the server as
> well. In itself lightweight VB apps but they were polling the database all
> the time hence processor as busy about70-80% all of the time.
>
> We learned that on a PC architecture CPU needs to drop below 30% or so to
> let at low level data caches to be flushed to disk. If CPU keeps above this
> point the data will build up and the database will get progressively show.
> We saw processor time being 80% at first, slower and slower database as we
> went along over a 5 minutes period say, then everything got soo slow
> virtually halting everybodies sessions (25-50 users). CPU dropped on the
> server below 30% and data was flushed to disk. After that performance was ok
> again for a few minutes before the whole things started again.
>
> We learned to have nothing on the server running apart from the DB itself.
> Give the DB nice disks each with its own controller and large cache.

Gerrit,

Was the NT File cache turned off?

just wondering,

Paul Received on Mon Jul 09 2001 - 21:25:34 CDT