Re: Oracle performance under NT

I had a project migrating an OTL (online transaction system) application from os2 TO WINDOWS nt4.0
at ricoh espc in amsterdam holland. NT40 clogged up when about 30 people where
accessing the database concurrently. (adding an extra processor, raid10 controller,
and 256meg (yes!) of memory to the machine didn't help at all. Not even a slight
improvement. (I learned the hard way that NT40 isn't scalable.) After close examination it seems that NT40 stops when to many processes (28 to be exactly) are waiting for blocking IO. The kernel doesn't get any processor time at all,
(flat-line on the task manager monitor)!!

/Jacob

Thomas Pall <tpall_at_bga.com> schreef in artikel <367847a9.0_at_feed1.realtime.net>...
> It is entirely possible. However much will depend on how many indexes
> have to be updated, amount of contention between users, how large your
> SGN is, how fast and how many CPUs you have. You would certainly want to

> go through the Oracle Server Tuning Manual and do everything you can to
> speed things up.
>
> Michael Ho (hom_at_loyal-holding.com) wrote:
>
>
> : Stephen Vear wrote:
>
> : > Does anybody have any performance statistics for Oracle running on NT
? We
> : > are considering a system that will have to perform about 40 table
inserts
> : > per second for a period every day. The inserts are about 6
attributes each.
> : > We basically want to know whether this sort of performance can be
achieved
> : > on an NT platform, or if we need to look to Unix.
> : >
> : > Any case histories are appreciated
> : >
> : > Stephen Vear
> : > vears_at_logica.com
>
> : 40 table insert is okey for NT. Of course depend on your hardware
setup,
> : database design, database size, etc.
>
> : General Advice 1 : Never underestimate the system requirement, there
are always
> : some later come requirment cost 10 times of your resources.
> : General Advice 2 : Never undersize your hardware, 'cause it is
generally cheap
> : right now.
>
>
Received on Sat Dec 19 1998 - 15:20:35 CST