Storage Device Benchmark Performance

Q

Where to find SQLIO Benchmark Performance results with 64-KB and 1-MB blocks on different storage devices?

✍: FYIcenter.com

A

Here are some SQLIO 64-KB and 1-MB benchmark test results on different hard disks we have collected so far.

All tests are using these common options: "-LS -i64 -f64 -t1 -p0 -s300".

Test results of reading data with "-kR":

Mode   Type         Device               System       Block Size  MBs/sec
----   ----         ---------            ------       ----------  ------
Read   Virtual HD   Azure ATA Device C:  Windows 10         -b64   472.10
Read   Virtual HD   Azure ATA Device D:  Server 2016        -b64   348.80
Read   SS Disk      SSDPEKKF256G8L       Windows 10         -b64   243.97
Read   Virtual HD   Azure ATA Device C:  Server 2016        -b64   232.13
Read   Virtual HD   Azure ATA Device D:  Windows 10         -b64    49.48
Read   Flash Drive  Cruzer Micro         Windows 7          -b64    24.71
Read   Flash Drive  DataTraveler 101     Windows 7          -b64    15.17
Read   Flash Drive  Cruzer Blade         Windows 7          -b64    14.96 
Read   Hard Disk    WD5000LPLX-08ZNT     Windows 7          -b64     8.77
Read   Hard Disk    ST500DM002-1BD142    Windows 7          -b64     7.94

Read   Virtual HD   Azure ATA Device D:  Windows 10       -b1024  4496.36
Read   SS Disk      SSDPEKKF256G8L       Windows 10       -b1024  1056.59
Read   Virtual HD   Azure ATA Device C:  Server 2016      -b1024   420.06
Read   Hard Disk    ST500DM002-1BD142    Windows 7        -b1024    59.58
Read   Hard Disk    WD5000LPLX-08ZNT     Windows 7        -b1024    53.48
Read   Virtual HD   Azure ATA Device C:  Windows 10       -b1024    35.22

Test results of writing data with "-kW":

Mode   Type         Device               System       Block Size  MBs/sec
----   ----         ---------            ------       ----------  -------
Write  SS Disk      SSDPEKKF256G8L       Windows 10         -b64   612.38
Write  Virtual HD   Azure ATA Device D:  Server 2016        -b64   344.54
Write  Hard Disk    ST500DM002-1BD142    Windows 7          -b64    33.86
Write  Hard Disk    WD5000LPLX-08ZNT     Windows 7          -b64    30.45
Write  Virtual HD   Azure ATA Device D:  Windows 10         -b64    25.01
Write  Virtual HD   Azure ATA Device C:  Server 2016        -b64    12.43
Write  Virtual HD   Azure ATA Device C:  Windows 10         -b64    11.68
Write  Flash Drive  Cruzer Blade         Windows 7          -b64     3.89 
Write  Flash Drive  DataTraveler 101     Windows 7          -b64     0.21
Write  Flash Drive  Cruzer Micro         Windows 7          -b64     0.11

Write  Virtual HD   Azure ATA Device D:  Windows 10       -b1024  4385.23
Write  SS Disk      SSDPEKKF256G8L       Windows 10       -b1024   498.81
Write  Hard Disk    ST500DM002-1BD142    Windows 7        -b1024    72.48
Write  Hard Disk    WD5000LPLX-08ZNT     Windows 7        -b1024    55.84
Write  Virtual HD   Azure ATA Device C:  Server 2016      -b1024    39.48
Write  Virtual HD   Azure ATA Device C:  Windows 10       -b1024    23.77

 

Storage Device Maximum Speed Summary

Storage Device Types and Models Tested

SQLIO Test Result Summary

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-05-05, 171👍, 0💬