SQL Server Performance

optimal segment size for RAID 10 array

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by SQLDBcontrol, Nov 20, 2008.

  1. SQLDBcontrol New Member

    Sorry for the double post - I accidentally posted in the SQL 2000 forum.[:$]
    We're implementing a RAID 10 array for the data portion of a VLDB, which is mainly used for random reads.
    Is there an optimal segment size I should be setting the array to? I've seen 64k being mentioned, and it makes sense given the size of an extent is 64k.
    Can anyone share their experience in this regard or offer any documented evidence as to what the optimal segment size is?
    Thanks,
    SQLDBcontrol, Nov 20, 2008
    #2

  2. satya Moderator

    No issues, appreciate your reference here and this thread is locked.
    satya, Nov 26, 2008
    #3

Share This Page