SQL Server supports a maximum sector size of 4096 bytes

Question

I am trying to install SQL Server 2012 (Developer Edition). It fails with message

Cannot use file 'D:\SQL\tempdb.mdf', because it is on a volume with sector size 8192. SQL Server supports a maximum sector size of 4096 bytes. Move the file to a volume with a compatible sector size.

But fsutil fsinfo ntfsinfo d: shows:

NTFS Volume Serial Number:       0x281643d216439fa4
NTFS Version:                    3.1
LFS Version:                     2.0
Number Sectors:                  0x00000000e8d29fff
Total Clusters:                  0x000000003a34a7ff
Free Clusters:                   0x000000002a37c684
Total Reserved:                  0x0000000000000000
Bytes Per Sector:                1024
Bytes Per Physical Sector:       4096
Bytes Per Cluster:               4096
Bytes Per FileRecord Segment:    1024
Clusters Per FileRecord Segment: 0
Mft Valid Data Length:           0x000000000a540000
Mft Start Lcn:                   0x00000000000c0000
Mft2 Start Lcn:                  0x0000000000000002
Mft Zone Start:                  0x00000000000ca540
Mft Zone End:                    0x00000000000cc820
RM Identifier:                   F3BAAB08-F2E7-11E2-804B-3C4A9279C348

D: drive is RAID 0 drive with total capacity of 4 TB made from two 2 TB disks. RAID controller is AMD RAID and its utility shows that disk's sector size is 1 KB:

Why SQL Server setup program thinks that disk sector size is 8K and what needs to be done to install SQL Server on this disk?

Answer 1

Looks like it is a bug in latest version of AMD RAID driver. Installing older version (3.2.1540.75) of the driver fixed the problem.

Answer 2

Maybe this link will help.

1KB sector size is exotic value. Usually it is 512 for older and 4K for newer drives. For sql server, RAID stripe size is recommended to be 64KB, and also format the partition with 64KB allocation unit/cluster size.