Azure Virtual HD on Windows 10 as D: - Maximum Reading Speed

Q

What is maximum reading speed of the Azure Virtual HD on Windows 10 as the application drive "D:"?

✍: FYIcenter.com

A

The best way to find out the maximum reading speed of your Azure Virtual HD as the application drive "D:" is to run reading tests with a single large block of different block sizes:

sqlio -LS -kR -i1 -f1 -t1 -s30 -p0 ...

If we run SQLIO with above options and different block sizes, we should be able to find the maximum reading speed:

             Throughput   Throughput   Latency
Block Size      MBs/sec      IOs/sec        ms
----------   ----------   ----------   -------
      -b16       189.79     12146.85         0
      -b64       733.64     11738.29         0
     -b256      2027.99      8111.98         0
    -b1024      4117.36      4117.36         0
    -b4096      5268.79      1317.19         0
   -b16384      4964.62       310.28         2
   -b65536       107.67         1.68       594
  -b262144        56.71         0.22      4512

As you can see, the maximum reading speed, 5268.79 MBs/sec is reached with a block size of "-b4096", or 4 MB.

 

Azure Virtual HD on Windows 10 as D: - Maximum Writing Speed

Azure Virtual HD on Windows 10 as D: - 1-MB Benchmark

I/O Tests on Azure Virtual HD and Storage

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-06-01, 123👍, 0💬