SQLIO Performance tests of a 2 TB Intel P3700 NVMe PCIe SSD on a Dell r710

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).

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

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

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

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