SQL Server Performance

best raid stripe size

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by pneth, Aug 9, 2006.

  1. pneth New Member

    We are setting up a new ibm xserve server for OLTP. this is for dual channel RAID10 drive.

    The SCSI serveRAID controller says to use 16kb stripe for generic
    "transaction processing database" (not sql server specific).

    posts I have seen say to use scsi controller defaults unless you have a reason. but 16k stripe size seems odd for sql server. should we switch to 64kb stripes?
  2. joechang New Member

    the HP/Compaq Smart Array controllers usually defaulted to 128K,

    try to find which specific IBM controller you are using,
    including whether it is a LSI, Mylex etc,
    I would not have thought that anything recent would be suggesting 16k
  3. pneth New Member

    This is not SAN
    ibm part 39R8816 IBM ServeRAID-6M SCSI Controller (256MB Cache)

    I have been trying to locate the manufacturer with no luck.

    the 16kb seems pretty small.

  4. pneth New Member

    It was manufactured by adaptec. I am trying to find the adaptec pn.
  5. joechang New Member

    are you sure about Adaptec? i thought the 6M was a LSI,
    look at the driver for this controller
    is it: mraid.sys or something else?

    anyways, this is a relatively recent generation controller,
    and i find it strange they are recommending 16k,
    i would think most should be 64k,
  6. pneth New Member

    You can see adaptec on the system board. Here is a link, how to identify which model "serveRaid". i am trying to find the exact same adaptec par number.

    http://www.redbooks.ibm.com/abstracts/TIPS0054.html?Open#ServeRAID-6M


    Storage controller (RAID)
    • 2 Channel
    • Ultra320 SCSI
    • 320 MBps
    • RAID 0
    • 1
    • 5
    • 10
    • 50
    • 1E
    • 1E0
    • 00
    • 5EE
    • PCI-X
  7. pneth New Member

    The RAID driver is nfrd960.sys

Share This Page