Virtual HD ATA Device on Server 2016 - 64-KB Benchmark

Q

What is the 64-KB I/O benchmark performance of Virtual HD ATA Device on Azure VM?

✍: FYIcenter.com

A

The I/O performance of reading and writing 64-KB files of a Virtual HD ATA Device can be measured by running SQLIO with multiple 64-KB blocks with a large stripe factor.

Here is the read performance test of Virtual HD ATA Device on Azure VM with 64-KB blocks.

C:\fyicenter\SQLIO>sqlio -LS -kR -b64 -i64 -f64 -t1 -s30 -p0

using system counter for latency timings, 10000000 counts per second
1 thread reading for 300 secs from file testfile.dat
  using 64KB IOs over 4096KB stripes with 64 IOs per run
  affinity on cpu number 0
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:  3714.23
MBs/sec:   232.13
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 403
histogram:
ms: 0  1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 97  2  1  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0

Here is the write performance test of Virtual HD ATA Device on Azure VM on 64-KB blocks.

C:\fyicenter\SQLIO>sqlio -LS -kW -b64 -i64 -f64 -t1 -s30 

using system counter for latency timings, 10000000 counts per second
1 thread writing for 300 secs to file testfile.dat
  using 64KB IOs over 4096KB stripes with 64 IOs per run
  affinity on cpu number 0
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:   198.98
MBs/sec:    12.43
latency metrics:
Min_Latency(ms): 3
Avg_Latency(ms): 4
Max_Latency(ms): 411
histogram:
ms: 0  1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%:  0  0  0 14 69 10  3  1  1  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  1

As you can see, in the simulation of multiple 64-KB file I/O, reading speed is 232.13 MBs/sec, and writing speed is 12.43 MBs/sec. So for a Virtual HD ATA Device, reading is much faster than writing.

 

Virtual HD ATA Device on Server 2016 - 1-MB Benchmark

Azure Virtual HD on Server 2016 - SQLIO Tests

I/O Tests on Azure Virtual HD and Storage

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-07-09, 1207🔥, 0💬