Re: NT/ORACLE/RAID and Performance PAIN

Ross,

You didn't mention you filesystem type?(NTFS or FAT).

I would load the Oracle Perfmon extentions.

If you are being constrained to RAID5 by none dba's then I would explain the overhead in using RAID5. This usually sways them.

I would monitor the disk queues to illustrate the bottleneck on the disk controller.

To bump the performance on NT you can disable any unrequired services and set the Control_Panel->Network->Services->Server property to 'Maximize performance for Network Apps' (This will reduce the amount of memory allocated to the disk cache, which Oracle doesn't use)

Check the sql statements that are being executed, might be worth looking at SQLab www.quests.com.

Chris.

Ross Mohan wrote:
>
> Folks,
>
> I don't know if there is list expertise and/or interest on this, but
> I am plumbing for both...here goes:
>
> I am running 7.3.3 on NT4 sp3.
>
> Adaptec 7895 dual port controller. Hardware RAID 05 ( I know,
> I know, not something I can change ).
>
> Truly soft disk performance!
>
> NT Perfmon shows, among other things, many Asynchronous and Deferred
> Procedure Calls.
>
> Questions:
>
> How can I see what is really going on?
>
> What tweaks --- if any -- can I do inside NT to bump performance
> ( N.B. no "NT is self tuning" responses are needed, thanks! ;-> )
>
> What tweaks -- other than dumping RAID 05 -- can I do on the hardware
> RAID side?
>
> I am pulling my hair out.
Received on Mon Feb 15 1999 - 04:15:53 CST