SQL Server 2005 (Standard) Partition Allocation Unit Size
Posted on 2009-04-16
I have two new LUNS on a Fibre Channel EMC CX4-120 SAN.
The Operating System for SQL 2005 Server is Windows Server 2003 SP2 (64 bit). The LUNs are configured as:
1 x 500 GB (Raid 5) LUN presented to the SQL 2005 Server for sql database data files.
1 x 460 GB (Raid 10) LUN presented to the SQL 2005 Server for sql database log files.
I will use the diskpart command and set the alignment offset for both of the LUNs to 64. My question is when I format the two LUNs with Windows should I use a particular NTFS allocation unit size? I was thinking of an allocation unit size of 4KB but I am getting mixed views from different people on the Internet, most are suggesting 64kb? I have done lots of research on this but am getting confused.
Could someone with some solid knowledge in this area please provide me with their opinion.