Disk partition alignment for SQL Server 2008

DISKPART> list disk

  Disk ###  Status          Size        Free        Dyn     Gpt

  --------    -------------      -------      -------       ---       ---

  Disk 0    Online            136 GB      0 B

  Disk 1    Online            600 GB   600 GB

  Disk 2    Reserved       200 GB  1024 KB

  Disk 3    Reserved       100 GB  1024 KB

  Disk 4    Reserved       50 GB    1024 KB

  Disk 5    Reserved       600 GB  1024 KB

  Disk 6    Reserved       340 GB  1024 KB

  Disk 7    Reserved       150 GB  1024 KB

  Disk 8    Offline            100 GB  1024 KB

  Disk 9    Offline            50 GB    1024 KB

  Disk 10  Reserved       3000 GB      0 B                  *

DISKPART> select disk 1

Disk 1 is now the selected disk.

DISKPART> create partition primary align=1024

DiskPart succeeded in creating the specified partition.

DISKPART> assign letter=E

DiskPart successfully assigned the drive letter or mount point.

DISKPART> format fs=ntfs unit=64K label="db_disk" nowait

Run ‘fsutil fsinfo ntfsinfo’ for drive to see the file allocation unit size.

The Bytes Per Cluster value, which contains the file allocation unit size is highlighted in red.

C:\>fsutil fsinfo ntfsinfo E:
NTFS Volume Serial Number :                   0x14d20835d2081e1c
Version :                                                            3.1
Number Sectors :                                           0x000000004affe7ff
Total Clusters :                                                 0x000000000095ffcf
Free Clusters  :                                                0x00000000001dfe72
Total Reserved :                                              0x0000000000005998
Bytes Per Sector  :                                          512
Bytes Per Cluster :                                         65536
Bytes Per FileRecord Segment :               1024
Clusters Per FileRecord Segment :          0
Mft Valid Data Length :                                0x0000000000180000
Mft Start Lcn  :                                                 0x000000000000c000
Mft2 Start Lcn :                                                0x0000000000000001
Mft Zone Start :                                              0x000000000000c000
Mft Zone End :                                                0x000000000000cca0
RM Identifier:                                                  5082C02D-609E-11E3-A803-901B0E0D3627