SQL Server Performance

Stripe Size and cluster size for NTFS and RAID??

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by mr_vaughn, Aug 2, 2007.

  1. mr_vaughn New Member

    Busy building multiple DB servers.
    I know about the selection of the RAID type and which are best for which types with reading vs writing database.

    1. What is the suggested Stipe Size for a Logical Drive? ( varies per controller) default is 128Kb on RAID10 on
    2. Is it the biggest stipe size the best?
    3. Creating the partion on Windows using diskpart( W2k3) is it best to set the NTFS cluster to align. Can some some poitn me to an article on this, my searching has not revealed good results.
    4. What is the best NTFS cluster size?
    Thanks

  2. NorthHinkle New Member

    The KB article for cluster partition alignments is # 929491
  3. satya Moderator

Share This Page