Disk Partition Alignment Best Practices for SQL Server

Bytes per Cluster for Data/Log/TempDB disks: 65536    (64K)

Bytes per Cluster for OS, Application, Pagefile disks: 4096   (default 4K)

Check using:

fsutil fsinfo ntfsinfo d:

Default offset since Windows Server 2008 has been aligned at 1024k, may need to align to 1024k for disks formatted prior to Server 2008.

Check using:

wmic partition get BlockSize, StartingOffset, Name, Index

or

diskpart

select disk 1

list part

http://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx