SQLIO test of RAID 5 with 4 x Intel 520 SSDs on an HP SmartArray P420i controller
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
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 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 current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 28507.87 | |
MBs/sec: 222.71 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 68 | |
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+ | |
%: 4 2 92 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 32KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 12683.23 | |
MBs/sec: 396.35 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 4 | |
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+ | |
%: 4 0 0 0 45 45 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6970.57 | |
MBs/sec: 435.66 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 8 | |
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+ | |
%: 6 0 0 0 0 0 0 0 21 54 15 2 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 128KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 3666.68 | |
MBs/sec: 458.33 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 16 | |
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+ | |
%: 2 0 0 0 0 0 0 0 0 0 0 0 0 0 1 9 27 34 18 5 1 0 0 0 2 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 256KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 1915.52 | |
MBs/sec: 478.88 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 32 | |
Max_Latency(ms): 436 | |
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 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 98 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 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 current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 126928.21 | |
MBs/sec: 991.62 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 128 | |
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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 32KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 49431.49 | |
MBs/sec: 1544.73 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 58 | |
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+ | |
%: 30 61 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 64KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 26283.24 | |
MBs/sec: 1642.70 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 58 | |
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 35 27 14 8 4 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 128KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 13342.93 | |
MBs/sec: 1667.86 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 4 | |
Max_Latency(ms): 66 | |
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+ | |
%: 6 18 19 14 9 6 4 3 3 3 3 3 3 2 1 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 256KB random IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6716.09 | |
MBs/sec: 1679.02 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 9 | |
Max_Latency(ms): 82 | |
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+ | |
%: 2 10 13 12 10 8 6 4 3 2 2 1 1 1 1 1 1 1 1 1 1 1 2 2 14 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 149121.26 | |
MBs/sec: 1165.00 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 3 | |
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 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 32KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 42460.51 | |
MBs/sec: 1326.89 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 74 | |
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+ | |
%: 2 98 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 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 current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 21519.14 | |
MBs/sec: 1344.94 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 2 | |
Max_Latency(ms): 68 | |
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+ | |
%: 4 0 50 46 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 128KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 10721.31 | |
MBs/sec: 1340.16 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 5 | |
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+ | |
%: 0 0 0 0 0 87 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads writing for 360 secs to file D:\testfile.dat | |
using 256KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 5306.47 | |
MBs/sec: 1326.61 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 11 | |
Max_Latency(ms): 118 | |
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 0 0 0 0 0 0 97 2 0 0 0 0 0 0 0 0 0 0 0 1 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 8KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 132195.88 | |
MBs/sec: 1032.78 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 62 | |
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 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 32KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 47693.03 | |
MBs/sec: 1490.40 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 0 | |
Max_Latency(ms): 59 | |
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+ | |
%: 14 85 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 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 current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 25609.70 | |
MBs/sec: 1600.60 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
Max_Latency(ms): 71 | |
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+ | |
%: 4 27 39 27 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 128KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 13495.78 | |
MBs/sec: 1686.97 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 4 | |
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+ | |
%: 3 10 14 15 18 17 6 4 4 3 3 2 0 0 0 0 0 0 0 0 0 0 0 0 0 | |
sqlio v1.5.SG | |
using system counter for latency timings, 2343896 counts per second | |
8 threads reading for 360 secs from file D:\testfile.dat | |
using 256KB sequential IOs | |
enabling multiple I/Os per thread with 8 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 36864 MB for file: D:\testfile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 6755.31 | |
MBs/sec: 1688.82 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 8 | |
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+ | |
%: 1 8 14 15 14 15 7 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 2 3 19 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
ok