Re: Oracle/NT Server performance

In article <32A328E3.2693_at_uniserve.com> Jim Mular <"Mularj "@uniserve.com> writes:
>From: Jim Mular <"Mularj "@uniserve.com>
>Subject: Oracle/NT Server performance
>Date: Mon, 02 Dec 1996 11:07:15 -0800
 

>If you were running a NT Server (P-133 with 128Mb RAM, an Adaptec 2940
>with 2- 4.0 Gig Quantum Fireball SCSI drives mirrored by NT) with Oracle
>7.1 and were having performance issues (the drives are crunching
>constantly) what would be the first thing you would upgrade?
 

>I've been told that a processor and memory upgrade will improve the
>performance, but I would have thought due to the heavy disk activity
>that a better SCSI controller (maybe a 40Mbit ultra fast wide SCSI disk
>system) would be the best bet.

Are you using all of the available memory, or is it underutilized ? Increase the buffers if you can.

I'm unclear if you have 1 drive that is mirrored to another drive or if you have 2 drives that are mirrored.

The more drives the better. If you are experiencing heavy I/O activity it would be good to intelligently divide up the files across multiple drives (ie. index files on seperate disks from the data files and redo logs on there own disk). If this maxes the SCSI controller, install another one and have 2 controllers or switch to a larger bandwidth controller (maybe 2).

These are all tuning issues. You have to decide if you are maxing your CPU or are at the memory wall. Faster CPU'S and more memory can make things faster, the question is, what needs to improve and by how much to make a big enough difference for a positive payback. Received on Tue Dec 03 1996 - 00:00:00 CST