Last active
August 29, 2015 14:07
-
-
Save NickCraver/65a497c86a4762f97019 to your computer and use it in GitHub Desktop.
Initial SQLIO Results from an Intel 800GB P3700
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, 2636721 counts per second | |
8 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) | |
using current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 219753.18 | |
MBs/sec: 1716.82 | |
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+ | |
%: 97 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:\Program Files (x86)\SQLIO>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS E:\Tes | |
tFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
8 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 current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 262703.36 | |
MBs/sec: 2052.37 | |
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 | |
C:\Program Files (x86)\SQLIO>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS E | |
:\TestFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
8 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 current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 29128.11 | |
MBs/sec: 1820.50 | |
latency metrics: | |
Min_Latency(ms): 0 | |
Avg_Latency(ms): 1 | |
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+ | |
%: 30 18 21 18 10 2 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 E | |
:\TestFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
8 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 current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 42731.58 | |
MBs/sec: 2670.72 | |
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+ | |
%: 35 30 35 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 -t64 -s120 -o64 -frandom -b8 -BH -LS E:\TestFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
64 threads writing for 120 secs to file E:\TestFile.dat | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 64 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 229377.41 | |
MBs/sec: 1792.01 | |
latency metrics: | |
Min_Latency(ms): 4 | |
Avg_Latency(ms): 17 | |
Max_Latency(ms): 44 | |
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 0 0 0 1 10 34 27 15 7 2 1 0 0 3 | |
C:\Program Files (x86)\SQLIO>sqlio -kR -t64 -s120 -o64 -frandom -b8 -BH -LS E:\TestFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
64 threads reading for 120 secs from file E:\TestFile.dat | |
using 8KB random IOs | |
enabling multiple I/Os per thread with 64 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 307739.25 | |
MBs/sec: 2404.21 | |
latency metrics: | |
Min_Latency(ms): 3 | |
Avg_Latency(ms): 12 | |
Max_Latency(ms): 41 | |
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 0 27 65 7 0 0 0 0 0 0 0 0 0 0 | |
C:\Program Files (x86)\SQLIO>sqlio -kW -t64 -s120 -o64 -fsequential -b64 -BH -LS E:\TestFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
64 threads writing for 120 secs to file E:\TestFile.dat | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 64 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 29616.56 | |
MBs/sec: 1851.03 | |
latency metrics: | |
Min_Latency(ms): 20 | |
Avg_Latency(ms): 137 | |
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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100 | |
C:\Program Files (x86)\SQLIO>sqlio -kR -t64 -s120 -o64 -fsequential -b64 -BH -LS E:\TestFile.dat | |
sqlio v1.5.SG | |
using system counter for latency timings, 2636721 counts per second | |
64 threads reading for 120 secs from file E:\TestFile.dat | |
using 64KB sequential IOs | |
enabling multiple I/Os per thread with 64 outstanding | |
buffering set to use hardware disk cache (but not file cache) | |
using current size: 24576 MB for file: E:\TestFile.dat | |
initialization done | |
CUMULATIVE DATA: | |
throughput metrics: | |
IOs/sec: 38400.59 | |
MBs/sec: 2400.03 | |
latency metrics: | |
Min_Latency(ms): 6 | |
Avg_Latency(ms): 106 | |
Max_Latency(ms): 189 | |
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 0 0 0 0 0 0 0 0 0 0 0 0 0 100 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment