none
Default block size for SQL Server? RRS feed

  • Question

  • What is the default block size for SQL Server? I am planning to move my SQL Server machine to AWS hence was trying gauge an understanding of the required IOPS in AWS.

    On the current physical machine I am getting the following via diskspd.

    68552.61 Max IOPS with 64k block size
    99815.91 Max IOPS with 16k block size

    however I want to know while comparing the machines in AWS shall I compare it on the basis of 16k block size or 64k block size?

    FYI, AWS does all the IOPS marketing on 16k block size.

    Any input is highly appreciated.


    Regards, Ashif Shaikh


    • Edited by Asif_DBA Tuesday, June 30, 2020 10:07 PM
    Tuesday, June 30, 2020 10:07 PM

All replies