Sql Server 2005 & Sql Server 2008 Raid 1 OPTIMAL Stripe Size and NTFS Allocation Unit Size
Posted on 2010-01-08
HP DL370 G6, Quad Core Xeon E5530 2.4 Ghz, 12 Gigs Ram, 410i 256 Embedded Controller.
3 Raid 1 Mirrors: 2x 146Gb 15k (OS), 2x 600Gb 15k (Sql Database(s)/Unstructured Data), 2x600Gb 15k (Sql Logfiles and unrelated Files).
Server 2008 R2 Standard 64 Bit, Initial Install of Sql Server 2005 and Upgrade to Sql Server 2008 when Accounting Application/Database is vendor certified for MS Sql Server 2008.
I have seen many different and conflicting expert recommendations on the net for Sql Server 2005/08 Optimal Raid 1 Stripe size and NTFS Allocation Unit Size for the Database and Logfiles. Would appreciate any expert technical advice here on the above. I am not soliciting information on the Raid 1 Selection. I am aware of the varying benefits of Raid 1, Raid 5 and Raid 10, etc in regards to read/write Database performance.
This server will be servicing a mission critical 4 Gigabyte and growing database for a 40 user environment with a maximum growth of ten employees in the next 4 years so I am not concerned with performance hits via the Raid Arrays for this server. I am most comfortable with 3 Raid 1 mirrors.
Any comments on the above as well as MBR and GPT Partition Style selection and Basic/Dynamic disks in Server 2008 from those who have built and deployed production database servers is most appreciated. More interested in practical experience rather than higher level theory.