Wednesday, November 26, 2014

Disk Partition Alignment Best Practices for SQL Server

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

No comments:

Post a Comment