Menu

vconfig.pl

Disk partition alignment for SQL Server 2008

by vconfig-admin
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 selecteddisk.
DISKPART> create partition primary align=1024
DiskPart succeededin creating the specified partition.
DISKPART> assign letter=E
DiskPart successfullyassigned the drive letter or mountpoint.
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 FileRecordSegment :               1024
Clusters Per FileRecordSegment :          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

Related articles