SQLIO test in iscsi mode


sqlio -kR -s20 -frandom -o512 -b1024 -BH -LS testfile.dat
sqlio v1.5.SG
using system counter for latency timings, -1894927296 counts per second
1 thread reading for 20 secs from file testfile.dat
using 1024KB random IOs
enabling multiple I/Os per thread with 512 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 8 MB for file: testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 110.21
MBs/sec: 110.21
latency metrics:
Min_Latency(ms): 192
Avg_Latency(ms): 4192
Max_Latency(ms): 4987
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

sqlio -kW -s20 -frandom -o512 -b1024 -BH -LS testfile.dat
sqlio v1.5.SG
using system counter for latency timings, -1894927296 counts per second
1 thread writing for 20 secs to file testfile.dat
using 1024KB random IOs
enabling multiple I/Os per thread with 512 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 8 MB for file: testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 64.54
MBs/sec: 64.54
latency metrics:
Min_Latency(ms): 194
Avg_Latency(ms): 6818
Max_Latency(ms): 8595
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

sqlio -kR -t1 -s30 -f64 -b2 -i64 -BN testfile.dat
sqlio v1.5.SG
1 thread reading for 30 secs from file testfile.dat
using 2KB IOs over 128KB stripes with 64 IOs per run
buffering set to not use file nor disk caches (as is SQL Server)
size of file testfile.dat needs to be: 8388608 bytes
current file size: 0 bytes
need to expand by: 8388608 bytes
expanding testfile.dat ... done.
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 5825.56
MBs/sec: 11.37

sqlio -kW -t1 -s30 -f64 -b2 -i64 -BN testfile.dat
sqlio v1.5.SG
1 thread writing for 30 secs to file testfile.dat
using 2KB IOs over 128KB stripes with 64 IOs per run
buffering set to not use file nor disk caches (as is SQL Server)
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 922.26
MBs/sec: 1.80

sqlio -kR -t1 -s30 -f64 -b2 -i64 -BY testfile.dat
sqlio v1.5.SG
1 thread reading for 30 secs from file testfile.dat
using 2KB IOs over 128KB stripes with 64 IOs per run
buffering set to use both file and disk caches
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 281238.06
MBs/sec: 549.29

sqlio -kW -t1 -s30 -f64 -b2 -i64 -BY testfile.dat
sqlio v1.5.SG
1 thread writing for 30 secs to file testfile.dat
using 2KB IOs over 128KB stripes with 64 IOs per run
buffering set to use both file and disk caches
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 269913.43
MBs/sec: 527.17