Last active
August 29, 2015 14:27
-
-
Save NickCraver/a1fb9de12b97eca48ab3 to your computer and use it in GitHub Desktop.
Stack Overflow SQLIO Numbers
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Dual Intel P3700 2TB PCIe NVMe SSD Drives in a RAID 0 | |
| C:\Program Files (x86)\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| size of file D:\testfile.dat needs to be: 21474836480 bytes | |
| current file size: 0 bytes | |
| need to expand by: 21474836480 bytes | |
| expanding D:\testfile.dat ... done. | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| interrupted by Ctrl-C - stopping I/Os now | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 192252.95 | |
| MBs/sec: 1501.97 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 94 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| Terminate batch job (Y/N)? | |
| ^CThe system cannot open the device or file specified. | |
| PS C:\Program Files (x86)\SQLIO> | |
| PS C:\Program Files (x86)\SQLIO> .\test.bat | |
| C:\Program Files (x86)\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 197772.38 | |
| MBs/sec: 1545.09 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 109 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 103240.51 | |
| MBs/sec: 806.56 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 34 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 50783.18 | |
| MBs/sec: 3173.94 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 101 | |
| 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 | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 41353.90 | |
| MBs/sec: 2584.61 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 20 | |
| 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+ | |
| %: 98 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>echo UNBUFFERED | |
| UNBUFFERED | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 10 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 194973.53 | |
| MBs/sec: 1523.23 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 54 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 46508.11 | |
| MBs/sec: 2906.75 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 126 | |
| 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+ | |
| %: 96 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 25052.48 | |
| MBs/sec: 3131.56 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 116 | |
| 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+ | |
| %: 90 7 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 13094.71 | |
| MBs/sec: 3273.67 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 175 | |
| 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+ | |
| %: 53 38 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 194914.68 | |
| MBs/sec: 1522.77 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 155 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 49037.38 | |
| MBs/sec: 3064.83 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 125 | |
| 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 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 24701.28 | |
| MBs/sec: 3087.66 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 150 | |
| 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+ | |
| %: 89 8 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 12882.95 | |
| MBs/sec: 3220.73 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 117 | |
| 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+ | |
| %: 54 35 7 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 103348.12 | |
| MBs/sec: 807.40 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 40 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 37574.85 | |
| MBs/sec: 2348.42 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 33 | |
| 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+ | |
| %: 98 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 23475.11 | |
| MBs/sec: 2934.38 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 26 | |
| 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+ | |
| %: 93 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 14273.36 | |
| MBs/sec: 3568.34 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 37 | |
| 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+ | |
| %: 59 37 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 76147.00 | |
| MBs/sec: 594.89 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 27 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 41572.30 | |
| MBs/sec: 2598.26 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 33 | |
| 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+ | |
| %: 98 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 29280.25 | |
| MBs/sec: 3660.03 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 30 | |
| 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 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 17941.16 | |
| MBs/sec: 4485.29 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 34 | |
| 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+ | |
| %: 91 7 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 24x 10K RPM 1.2 TB SAS HDDs in a RAID 10 | |
| C:\Program Files (x86)\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| size of file E:\testfile.dat needs to be: 21474836480 bytes | |
| current file size: 0 bytes | |
| need to expand by: 21474836480 bytes | |
| expanding E:\testfile.dat ... done. | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 9685.34 | |
| MBs/sec: 75.66 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 8 | |
| 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+ | |
| %: 15 59 23 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 3341.12 | |
| MBs/sec: 26.10 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 4 | |
| Max_Latency(ms): 160 | |
| 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+ | |
| %: 5 12 13 14 15 16 11 3 2 2 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 28880.70 | |
| MBs/sec: 1805.04 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 8 | |
| 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+ | |
| %: 81 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 37073.32 | |
| MBs/sec: 2317.08 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 470 | |
| 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+ | |
| %: 90 6 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>echo UNBUFFERED | |
| UNBUFFERED | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 10 secs to file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 11224.70 | |
| MBs/sec: 87.69 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 5 | |
| 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+ | |
| %: 29 49 19 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 5096.64 | |
| MBs/sec: 318.54 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 2 | |
| Max_Latency(ms): 11 | |
| 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 13 36 30 14 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 2699.50 | |
| MBs/sec: 337.43 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 5 | |
| Max_Latency(ms): 25 | |
| 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 3 11 20 23 19 12 7 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 1408.08 | |
| MBs/sec: 352.02 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 10 | |
| Max_Latency(ms): 65 | |
| 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 0 0 1 3 7 11 14 15 14 10 8 5 3 2 1 1 1 0 0 0 0 1 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 132379.11 | |
| MBs/sec: 1034.21 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 24 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 29155.07 | |
| MBs/sec: 1822.19 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 5 | |
| 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+ | |
| %: 81 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 17212.54 | |
| MBs/sec: 2151.56 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 11 | |
| 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+ | |
| %: 55 45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 6642.59 | |
| MBs/sec: 1660.64 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 43 | |
| 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+ | |
| %: 1 19 68 10 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 3694.42 | |
| MBs/sec: 28.86 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 3 | |
| Max_Latency(ms): 416 | |
| 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+ | |
| %: 13 11 12 13 14 15 10 3 2 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 2546.10 | |
| MBs/sec: 159.13 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 5 | |
| Max_Latency(ms): 99 | |
| 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+ | |
| %: 9 2 6 9 13 17 16 5 4 4 3 3 2 1 1 1 1 1 0 0 0 0 0 0 1 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 1902.83 | |
| MBs/sec: 237.85 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 7 | |
| Max_Latency(ms): 100 | |
| 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+ | |
| %: 8 0 2 4 8 14 17 6 6 5 5 5 4 2 2 2 2 2 1 1 1 1 1 1 2 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 1329.05 | |
| MBs/sec: 332.26 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 11 | |
| Max_Latency(ms): 120 | |
| 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+ | |
| %: 8 0 0 1 2 7 12 6 6 6 6 7 6 3 3 3 3 3 2 1 2 2 2 1 8 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 56568.68 | |
| MBs/sec: 441.94 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 32 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 36496.46 | |
| MBs/sec: 2281.02 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 293 | |
| 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+ | |
| %: 89 7 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 18616.44 | |
| MBs/sec: 2327.05 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 190 | |
| 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+ | |
| %: 76 11 6 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\Program Files (x86)\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\Program Files (x86)\SQLIO>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 3125001 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 9448.73 | |
| MBs/sec: 2362.18 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 139 | |
| 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+ | |
| %: 50 18 13 7 5 3 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Single Intel P3700 2TB PCIe NVMe SSD Drive | |
| C:\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 383.27 | |
| MBs/sec: 2.99 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 41 | |
| Max_Latency(ms): 295 | |
| 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+ | |
| %: 46 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 1 0 0 0 0 0 0 38 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 46392.79 | |
| MBs/sec: 362.44 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 176 | |
| 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 23205.32 | |
| MBs/sec: 1450.33 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 251 | |
| 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+ | |
| %: 90 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 25764.47 | |
| MBs/sec: 1610.27 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 67 | |
| 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 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>echo UNBUFFERED | |
| UNBUFFERED | |
| C:\SQLIO>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 10 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 128992.20 | |
| MBs/sec: 1007.75 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 121 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 24916.76 | |
| MBs/sec: 1557.29 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 161 | |
| 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+ | |
| %: 88 9 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 12899.56 | |
| MBs/sec: 1612.44 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 101 | |
| 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+ | |
| %: 51 35 10 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 6442.84 | |
| MBs/sec: 1610.71 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 112 | |
| 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 52 35 7 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 132672.28 | |
| MBs/sec: 1036.50 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 166 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 24197.04 | |
| MBs/sec: 1512.31 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 160 | |
| 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+ | |
| %: 87 10 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 12994.84 | |
| MBs/sec: 1624.35 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 105 | |
| 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+ | |
| %: 51 34 10 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 6446.60 | |
| MBs/sec: 1611.65 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 146 | |
| 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 55 34 6 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 76988.74 | |
| MBs/sec: 601.47 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 148 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 21716.58 | |
| MBs/sec: 1357.28 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 37 | |
| 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+ | |
| %: 92 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 13228.88 | |
| MBs/sec: 1653.61 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 99 | |
| 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+ | |
| %: 61 34 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 8034.83 | |
| MBs/sec: 2008.70 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 101 | |
| 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 77 18 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 50345.84 | |
| MBs/sec: 393.32 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 161 | |
| 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+ | |
| %: 98 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 26162.16 | |
| MBs/sec: 1635.13 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 37 | |
| 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 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 15908.09 | |
| MBs/sec: 1988.51 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 98 | |
| 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+ | |
| %: 87 9 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 8048.95 | |
| MBs/sec: 2012.23 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 87 | |
| 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 91 3 2 1 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 24x Intel 710 200GB SATA SSDs in a RAID 10 | |
| C:\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| size of file E:\testfile.dat needs to be: 21474836480 bytes | |
| current file size: 0 bytes | |
| need to expand by: 21474836480 bytes | |
| expanding E:\testfile.dat ... done. | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 28712.87 | |
| MBs/sec: 224.31 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 76 | |
| 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+ | |
| %: 79 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 45481.24 | |
| MBs/sec: 355.32 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 53 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 15149.81 | |
| MBs/sec: 946.86 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 341 | |
| 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+ | |
| %: 56 42 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 28817.03 | |
| MBs/sec: 1801.06 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 81 | |
| 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+ | |
| %: 96 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>echo UNBUFFERED | |
| UNBUFFERED | |
| C:\SQLIO>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 10 secs to file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 27607.00 | |
| MBs/sec: 215.67 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 79 | |
| 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+ | |
| %: 81 19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 13691.77 | |
| MBs/sec: 855.73 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 289 | |
| 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+ | |
| %: 54 38 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 7307.43 | |
| MBs/sec: 913.42 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 443 | |
| 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 53 44 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 3717.50 | |
| MBs/sec: 929.37 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 3 | |
| Max_Latency(ms): 451 | |
| 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 2 46 48 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 104479.63 | |
| MBs/sec: 816.24 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 223 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 15224.85 | |
| MBs/sec: 951.55 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 383 | |
| 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+ | |
| %: 64 34 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 7612.70 | |
| MBs/sec: 951.58 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 152 | |
| 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+ | |
| %: 16 26 57 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 3800.62 | |
| MBs/sec: 950.15 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 3 | |
| Max_Latency(ms): 157 | |
| 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+ | |
| %: 7 11 3 11 65 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 47603.41 | |
| MBs/sec: 371.90 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 224 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 18563.48 | |
| MBs/sec: 1160.21 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 372 | |
| 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+ | |
| %: 86 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 12838.20 | |
| MBs/sec: 1604.77 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 328 | |
| 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+ | |
| %: 28 70 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 7375.77 | |
| MBs/sec: 1843.94 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 298 | |
| 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 42 53 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 102670.45 | |
| MBs/sec: 802.11 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 133 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 27783.38 | |
| MBs/sec: 1736.46 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 170 | |
| 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+ | |
| %: 93 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 14938.80 | |
| MBs/sec: 1867.35 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 107 | |
| 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+ | |
| %: 48 51 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2636720 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 7696.23 | |
| MBs/sec: 1924.05 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 167 | |
| 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 44 55 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Dual Intel P3600 2TB PCIe NVMe SSD Drives in a RAID 0 | |
| C:\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| size of file D:\testfile.dat needs to be: 21474836480 bytes | |
| current file size: 0 bytes | |
| need to expand by: 21474836480 bytes | |
| expanding D:\testfile.dat ... done. | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 175587.23 | |
| MBs/sec: 1371.77 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 22 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 112144.90 | |
| MBs/sec: 876.13 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 16 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 48618.53 | |
| MBs/sec: 3038.65 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 24 | |
| 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+ | |
| %: 94 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 46865.02 | |
| MBs/sec: 2929.06 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 15 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>echo UNBUFFERED | |
| UNBUFFERED | |
| C:\SQLIO>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 10 secs to file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 173623.30 | |
| MBs/sec: 1356.43 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 22 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 45913.33 | |
| MBs/sec: 2869.58 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 25 | |
| 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+ | |
| %: 93 6 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 21414.15 | |
| MBs/sec: 2676.76 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 28 | |
| 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+ | |
| %: 79 15 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 10841.56 | |
| MBs/sec: 2710.39 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 27 | |
| 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+ | |
| %: 41 40 12 4 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 179768.67 | |
| MBs/sec: 1404.44 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 23 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 43427.64 | |
| MBs/sec: 2714.22 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 26 | |
| 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+ | |
| %: 93 5 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 20864.79 | |
| MBs/sec: 2608.09 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 28 | |
| 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+ | |
| %: 78 15 5 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file D:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 10686.88 | |
| MBs/sec: 2671.72 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 29 | |
| 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+ | |
| %: 44 35 13 5 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 111384.26 | |
| MBs/sec: 870.18 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 22 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 37996.00 | |
| MBs/sec: 2374.75 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 24 | |
| 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+ | |
| %: 99 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 25035.89 | |
| MBs/sec: 3129.48 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 26 | |
| 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+ | |
| %: 93 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 15521.98 | |
| MBs/sec: 3880.49 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 26 | |
| 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+ | |
| %: 60 37 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 82386.68 | |
| MBs/sec: 643.64 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 15 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 46692.20 | |
| MBs/sec: 2918.26 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 22 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 31977.03 | |
| MBs/sec: 3997.12 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 25 | |
| 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+ | |
| %: 98 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam-D.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-D.txt | |
| file D:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file D:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: D:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 19589.70 | |
| MBs/sec: 4897.42 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 19 | |
| 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+ | |
| %: 93 5 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 16x 7200 RPM 6TB 3.5" HDDs in a RAID 10 | |
| C:\SQLIO>echo BUFFERED | |
| BUFFERED | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| size of file E:\testfile.dat needs to be: 21474836480 bytes | |
| current file size: 0 bytes | |
| need to expand by: 21474836480 bytes | |
| expanding E:\testfile.dat ... done. | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 5682.25 | |
| MBs/sec: 44.39 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 2 | |
| Max_Latency(ms): 42 | |
| 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+ | |
| %: 13 22 25 20 11 5 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 2136.41 | |
| MBs/sec: 16.69 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 7 | |
| Max_Latency(ms): 322 | |
| 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+ | |
| %: 3 7 9 9 10 10 10 10 10 6 2 2 2 2 1 1 1 1 1 0 0 0 0 0 2 | |
| C:\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 120 secs to file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 24470.66 | |
| MBs/sec: 1529.41 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 14 | |
| 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+ | |
| %: 79 21 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 120 secs from file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| buffering set to use hardware disk cache (but not file cache) | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 17550.30 | |
| MBs/sec: 1096.89 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 410 | |
| 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+ | |
| %: 83 6 3 2 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>echo UNBUFFERED | |
| UNBUFFERED | |
| C:\SQLIO>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 10 secs to file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 7446.90 | |
| MBs/sec: 58.17 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 12 | |
| 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+ | |
| %: 34 15 20 17 9 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 2661.75 | |
| MBs/sec: 166.35 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 5 | |
| Max_Latency(ms): 102 | |
| 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+ | |
| %: 1 4 6 10 15 17 16 12 8 5 3 2 1 1 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 1441.74 | |
| MBs/sec: 180.21 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 10 | |
| Max_Latency(ms): 89 | |
| 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 2 2 2 2 4 5 7 9 10 10 10 8 7 6 4 3 2 2 1 1 1 1 0 1 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 769.17 | |
| MBs/sec: 192.29 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 20 | |
| Max_Latency(ms): 194 | |
| 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 1 1 0 0 1 1 1 1 2 2 3 4 4 5 6 6 6 6 6 6 5 5 29 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 135434.42 | |
| MBs/sec: 1058.08 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 64 | |
| 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+ | |
| %: 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 24215.58 | |
| MBs/sec: 1513.47 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 237 | |
| 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+ | |
| %: 80 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 12515.48 | |
| MBs/sec: 1564.43 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 223 | |
| 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+ | |
| %: 35 59 4 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads writing for 360 secs to file E:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 6305.31 | |
| MBs/sec: 1576.32 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 2 | |
| Max_Latency(ms): 307 | |
| 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+ | |
| %: 1 15 73 5 4 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 8KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 2355.20 | |
| MBs/sec: 18.40 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 6 | |
| Max_Latency(ms): 383 | |
| 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+ | |
| %: 10 6 8 9 9 9 9 9 9 6 2 1 1 1 1 1 1 1 1 0 0 0 0 0 2 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 64KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 1525.11 | |
| MBs/sec: 95.31 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 10 | |
| Max_Latency(ms): 168 | |
| 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+ | |
| %: 7 1 2 4 5 7 8 10 11 10 4 3 3 3 3 3 3 3 1 1 1 1 1 1 6 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 128KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 1099.62 | |
| MBs/sec: 137.45 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 14 | |
| Max_Latency(ms): 178 | |
| 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+ | |
| %: 7 0 0 1 2 3 5 7 9 10 5 3 4 4 4 4 4 4 2 2 2 2 2 2 15 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 256KB random IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 769.34 | |
| MBs/sec: 192.33 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 20 | |
| Max_Latency(ms): 509 | |
| 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+ | |
| %: 7 0 0 0 0 1 1 3 5 7 4 3 3 4 4 4 5 5 3 2 2 2 2 2 31 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 8KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 119081.50 | |
| MBs/sec: 930.32 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 138 | |
| 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+ | |
| %: 99 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 64KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 17787.49 | |
| MBs/sec: 1111.71 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 0 | |
| Max_Latency(ms): 279 | |
| 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+ | |
| %: 83 6 3 2 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 128KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 10401.60 | |
| MBs/sec: 1300.20 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 1 | |
| Max_Latency(ms): 239 | |
| 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+ | |
| %: 65 14 7 4 3 2 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
| C:\SQLIO>timeout /T 5 | |
| Waiting for 0 seconds, press a key to continue ... | |
| C:\SQLIO>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam-E.txt | |
| sqlio v1.5.SG | |
| using system counter for latency timings, 2539068 counts per second | |
| parameter file used: param-E.txt | |
| file E:\testfile.dat with 2 threads (0-1) using mask 0x0 (0) | |
| 2 threads reading for 360 secs from file E:\testfile.dat | |
| using 256KB sequential IOs | |
| enabling multiple I/Os per thread with 8 outstanding | |
| using specified size: 20480 MB for file: E:\testfile.dat | |
| initialization done | |
| CUMULATIVE DATA: | |
| throughput metrics: | |
| IOs/sec: 5432.39 | |
| MBs/sec: 1358.09 | |
| latency metrics: | |
| Min_Latency(ms): 0 | |
| Avg_Latency(ms): 2 | |
| Max_Latency(ms): 544 | |
| 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+ | |
| %: 35 21 13 8 6 4 3 3 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment