SQL Server supports a maximum sector size of 4096 bytes


  • 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:

    RAID utility screenshot

    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?

    Saturday, July 27, 2013 10:31 PM


All replies

  • 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.
    Sunday, July 28, 2013 1:07 AM
  • 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.

    Sunday, July 28, 2013 1:15 AM