RAID 1 stripe size

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Wells Caughey (wellscaughey_at_hotmail.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 13:25:10 -0500

I am currently setting up a new SQL box that I intend to have two RAID
arrays: a RAID 5 for data files and OS and a RAID 1 for the log files. In
my previous RAID controllers I was only given a choice in for the RAID 5
stripe size, which I have set to 64K but this new controller I am using also
allows me to set a stripe size for the RAID 1 array. I would think that 64K
would be a bit big for log files, but I don't really know what I should use
here. Does anyone have any suggestions on how big this should be?

Thanks,
Wells

Relevant Pages

  • Re: 280R and A5200 question
    ... additional controller or fibre HBA? ... You seem to want RAID for some reason. ... stripe the six disks in the back. ... Then you can mirror across the arrays and even begin to ...
    (comp.unix.solaris)
  • RE: New install, save data on old second hdd..??
    ... I am pretty sure the Raid arrays are ok, they are in place, and a set by the ... My concern was with XPpro... ... I "initialted" the two old single IDE drives in the ...
    (microsoft.public.windowsxp.hardware)
  • Re: RAID LICENSE - any one using and having fun with it?
    ... For all the folks who provided answers talking about various controller hardware-based RAID implementations, note this is Host-Based RAID Software. ... The product was originally designed to do RAID-5 arrays, but later had added to it the capability of doing RAID-0 arrays and RAID 0+1 arrays in conjunction with Host-Based Volume Shadowing software. ... Writes using RAID-5 arrays will use more CPU time. ...
    (comp.os.vms)
  • RE: No go on the 3TB Raid
    ... No go on the 3TB Raid ... Tom Scales wrote: ... back to a pair of 1.5Tb arrays. ... drives, you get 2.7TB available for data as well as the ability to hot ...
    (alt.sys.pc-clone.dell)
  • Re: AHCI Implementation
    ... Raid 0 is a stripe set, the set has to be created then win installed on it ... second array for the other two drives. ... AHCI and Vista does not have a problem with the partitions on the boot ... and wth two arrays it works just fine with NCQ turned on for both arrays. ...
    (microsoft.public.windows.vista.general)