Windows 2000 and SAPDB 7.4, data disk advice, RAID

"Stephen Gutknecht (SAPDB)" <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Message-ID <FFF79285B87C7C4581BBDFA2921E4664FCC7A2@ipcoast05.ipcsite1.ipcoast.net>
Hi,
 
On Windows 2000....
 
have 4 36GB 15,000 RPM SCSI hard drives for the main storage.  Two channel
disk controller, put two drives on each channel.  64-bit PCI LSI/Mylex 352
controller.  For first round - I configured these 4 drives as  RAID 0+1
yielding 72GB of usable space.  Also formatted the partition with NTFS using
a 8K block size.
Log is on a dedicated 7200 RPM IDE drive with no other purpose (also on a
dedicated IDE controller channel).
 
Observations:
Watching kernel.exe with performance monitor, I/O performance on the main
data array seems to be about twice (2x) what a single 7200 RPM IDE drive on
dedicated channel was doing before.   Given the 2x spin rate and 2x drives
(raid 0), I expected a little more improvement (3x to 4s instead of only
2x).
 
Any thoughts or suggestions?  Is NTFS @ 8K block size ideal for SAPDB, or am
I overlooking something?
 
Obviously I could put the 4 drives all in a RAID 0 and get more
performance... which is an option as we have custom replication between our
two SAPDB servers.... but I am undecided if this gain is worth the potential
downtime/recovery time.
 
Thank you for any input.
 
  Stephen Gutknecht
  currently in Long Beach, California USA
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.