Skip to content

Instantly share code, notes, and snippets.

@NickCraver

NickCraver/Notes.txt

Last active August 29, 2015 14:07
Star
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
SQLIO Performance tests of a 2 TB Intel P3700 NVMe PCIe SSD on a Dell r710
Raw
Notes.txt
Notes: this is on a Dell R710 server running Windows 2012 Server Core (latest patches as of 2014-10-12) - access to NVMe drives is via a mini driver on this OS version.
We'll re-run these tests when these SSDs migrate to some new R730xd servers in about a month, when we rebuild the cluster on Windows 2012 R2 which has native NVMe support.
This is also in a currently inactive server while we do a burn-in test on the primary to ensure there are no issues with this storage setup. If you have additional SQLIO test configurations you want to see - ping me via @Nick_Craver and I'm happy to run when until we stick this into production on 2014-10-14 (2 days from now).
Raw
SQLIOPerf-P3700-2Cards-RAID0-Dellr710-buffered.txt
E:\>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3376957 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: 367707.72
MBs/sec: 2872.71
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
E:\>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3376957 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: 334866.74
MBs/sec: 2616.14
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
E:\>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3376957 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: 48952.77
MBs/sec: 3059.54
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
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+
%: 63 10 8 7 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3376957 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: 50526.88
MBs/sec: 3157.93
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 7
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+
%: 75 0 0 22 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Raw
SQLIOPerf-P3700-2Cards-RAID0-Dellr710-unbuffered.txt
E:\>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 threads writing for 10 secs to file e:\testfile.dat
using 8KB random IOs
enabling multiple I/Os per thread with 8 outstanding
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: 369895.00
MBs/sec: 2889.80
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+
%: 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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 48484.72
MBs/sec: 3030.29
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+
%: 55 19 13 10 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 24486.68
MBs/sec: 3060.83
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
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+
%: 19 20 20 21 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 12423.80
MBs/sec: 3105.95
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 10 11 10 9 9 9 9 10 13 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 376981.79
MBs/sec: 2945.17
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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 49128.31
MBs/sec: 3070.51
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
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+
%: 65 7 8 6 14 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 24551.72
MBs/sec: 3068.96
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
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+
%: 33 10 14 10 32 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 12500.17
MBs/sec: 3125.04
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 31 12 2 1 4 4 1 2 11 29 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 335008.25
MBs/sec: 2617.25
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+
%: 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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 50282.22
MBs/sec: 3142.63
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 7
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+
%: 47 35 15 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 25514.94
MBs/sec: 3189.36
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
Max_Latency(ms): 9
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+
%: 22 20 15 22 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 12774.43
MBs/sec: 3193.60
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 10 14 10 9 8 8 8 11 17 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 276010.08
MBs/sec: 2156.32
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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 50476.46
MBs/sec: 3154.77
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 10
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+
%: 75 0 0 22 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 25334.20
MBs/sec: 3166.77
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
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+
%: 50 0 0 0 49 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3376957 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 12812.97
MBs/sec: 3203.24
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
Max_Latency(ms): 13
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 0 0 0 0 0 0 0 0 49 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Raw
SQLIOPerf-P3700-Dellr710-buffered.txt
E:\>sqlio -kW -t8 -s120 -o8 -frandom -b8 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3247076 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: 202557.95
MBs/sec: 1582.48a
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+
%: 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
E:\>sqlio -kR -t8 -s120 -o8 -frandom -b8 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3247076 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: 204460.54
MBs/sec: 1597.34
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
E:\>sqlio -kW -t8 -s120 -o8 -fsequential -b64 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3247076 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: 26053.00
MBs/sec: 1628.31
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
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+
%: 33 14 8 16 29 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>sqlio -kR -t8 -s120 -o8 -fsequential -b64 -BH -LS E:\TestFile.dat
sqlio v1.5.SG
using system counter for latency timings, 3247076 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: 25398.76
MBs/sec: 1587.42
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
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+
%: 50 0 0 0 49 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Raw
SQLIOPerf-P3700-Dellr710-unbuffered.txt
E:\>sqlio -kW -s10 -frandom -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 threads writing for 10 secs to file e:\testfile.dat
using 8KB random IOsa
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: 205475.20
MBs/sec: 1605.27
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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -frandom -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 26044.60
MBs/sec: 1627.78
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 1
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+
%: 20 21 21 22 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -frandom -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 13256.46
MBs/sec: 1657.05
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 9 12 11 10 10 10 10 12 13 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -frandom -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 6654.92
MBs/sec: 1663.73
latency metrics:
Min_Latency(ms): 1
Avg_Latency(ms): 9
Max_Latency(ms): 35
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 2 95 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 206363.73
MBs/sec: 1612.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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 25985.46
MBs/sec: 1624.09
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
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+
%: 34 13 6 15 31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 13300.93
MBs/sec: 1662.61
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 29 15 4 1 1 1 2 9 30 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kW -s360 -fsequential -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 6644.89
MBs/sec: 1661.22
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 9
Max_Latency(ms): 35
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 2 94 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 202377.89
MBs/sec: 1581.07
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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 25051.05
MBs/sec: 1565.69
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
Max_Latency(ms): 9
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+
%: 22 19 15 20 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 12960.09
MBs/sec: 1620.01
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 9 13 10 9 9 9 9 11 16 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -frandom -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 6452.30
MBs/sec: 1613.07
latency metrics:
Min_Latency(ms): 2
Avg_Latency(ms): 9
Max_Latency(ms): 13
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 66 34 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b8 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 204392.67
MBs/sec: 1596.81
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 4
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
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b64 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 25394.61
MBs/sec: 1587.16
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 2
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+
%: 50 0 0 0 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b128 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 13065.88
MBs/sec: 1633.23
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 4
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+
%: 50 0 0 0 0 0 0 0 0 50 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
E:\>timeout /T 5
Waiting for 5 seconds, press a key to continue ...43210
E:\>sqlio -kR -s360 -fsequential -o8 -b256 -LS -Fparam.txt
sqlio v1.5.SG
using system counter for latency timings, 3247076 counts per second
parameter file used: param.txt
file e:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 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: 6531.79
MBs/sec: 1632.94
latency metrics:
Min_Latency(ms): 2
Avg_Latency(ms): 9
Max_Latency(ms): 13
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 92 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment