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

Q

What is maximum writing 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 writing speed of your Azure Virtual HD as the application drive "D:" is to run writing 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 writing speed:

             Throughput   Throughput   Latency
Block Size      MBs/sec      IOs/sec        ms
----------   ----------   ----------   -------
      -b16       196.81     12596.11         0
      -b64       736.58     11785.40         0
     -b256      2224.05      8896.21         0
    -b1024      4842.04      4842.04         0
    -b4096      6559.65      1639.91         0
   -b16384      5502.26       343.89         2
   -b65536        53.83         0.84      1187
  -b262144        28.38         0.11      9020

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

Comparing to the maximum reading speed of 5268.79 MBs/sec, the maximum writing speed of 6559.65 MBs/sec is about the same. So Azure Virtual HD as application drive "D:", is configured for high speed on reading and writing.

 

SQLIO Test Result Summary

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

I/O Tests on Azure Virtual HD and Storage

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-06-01, 179👍, 0💬