Configure Disk Allocation Unit Size to Maximize IOPS

When configuring a disk volume for use with SQL Server, it is best to configure the Allocation Unit Size appropriately to maximize IOPS (I/O operations/second).

o    Set to NTFS 64 KB for volumes containing mostly SQL data and log files.

o    Do not use default of 4096 bytes.

o    This is because SQL stores data in 8 K pages, and there are 8 pages/extent. Therefore 64 KB/extent. This will reduce the number of IOPS.

• https://blogs.msdn.microsoft.com/spucelik/2016/12/27/sql-server-disk-allocation-size/

After a new volume has been added, go to Computer Management, then Disk Management.