rjearley1966
asked on
Sql Server 2005 & Sql Server 2008 Raid 1 OPTIMAL Stripe Size and NTFS Allocation Unit Size
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.
Thanks,
Rich
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.
Thanks,
Rich
ASKER
Thanks Mike. Surprised there are no opinions out there on MBR and GPT partition styles. Tells me folks are playing it safe by going with what is known and familiar: MBR.
ASKER
Closed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For the cluster size/NTFS stripe size I have had good luck with 64k there as well. Your mileage my vary but this has worked out well on warehouse type workloads as well as OLTP workloads in my environments.
Good article: http://msdn.microsoft.com/en-us/library/dd758814.aspx