Storage Device Maximum Speed Summary

Q

Where to find maximum I/O speeds measured by SQLIO on different storage devices?

✍: FYIcenter.com

A

Here are maximum I/O speeds measured by SQLIO on some storage devices we have collected so far.

All tests are using these common options: "-LS -i1 -f1 -t1 -p0 -s300".

Test results of maximum reading speed with "-kR":

Mode   Type         Device               System      Block Size  MBs/sec
----   ----         ---------            ------      ----------  -------
Read   Virtual HD   Azure ATA Device D:  Windows 10      -b4096  5268.79
Read   Virtual HD   Azure ATA Device C:  Windows 10     -b16384  3904.09
Read   SS Disk      SSDPEKKF256G8L       Windows 10    -b262144  1459.28
Read   Hard Disk    WD5000LPLX-08ZNT     Windows 7       -b8192   378.95        
Read   Hard Disk    ST500DM002-1BD142    Windows 7       -b1024   216.56        
Read   Flash Drive  Cruzer Micro         Windows 7      -b16384    26.44
Read   Flash Drive  Cruzer Blade         Windows 7       -b1024    18.55 
Read   Flash Drive  DataTraveler 101     Windows 7         -b64    15.36
Read   Flash Drive  Attaché              Windows 7       -b8192     4.67

Test results of maximu writing speed with "-kW":

Mode   Type         Device               System      Block Size  MBs/sec
----   ----         ---------            ------      ----------  -------
Write  Virtual HD   Azure ATA Device D:  Windows 10      -b4096  6559.65
Write  SS Disk      SSDPEKKF256G8L       Windows 10     -b65536   910.41
Write  Hard Disk    WD5000LPLX-08ZNT     Windows 7       -b1024   317.47
Write  Hard Disk    ST500DM002-1BD142    Windows 7       -b1024   114.20        
Write  Virtual HD   Azure ATA Device C:  Windows 10     -b16384    97.49
Write  Flash Drive  Cruzer Blade         Windows 7        -b256     8.71
Write  Flash Drive  Cruzer Micro         Windows 7     -b262144     6.69
Write  Flash Drive  DataTraveler 101     Windows 7         -b64     3.14
Write  Flash Drive  Attaché              Windows 7       -b8192     4.51

 

SQLIO Disk I/O Benchmark Test Tutorials

Storage Device Benchmark Performance

SQLIO Test Result Summary

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-05-25, 137👍, 0💬