SQLIO實測

設定同SAN實做參考
http://forum.open-e.com/showthread.php?t=1309

sqlio -kR -s20 -frandom -o512 -b1024 -BH -LS testfile.dat
sqlio v1.5.SG
using system counter for latency timings, -1894937296 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:   178.70
MBs/sec:   178.70
latency metrics:
Min_Latency(ms): 147
Avg_Latency(ms): 2674
Max_Latency(ms): 3013
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, -1894937296 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:   167.64
MBs/sec:   167.64
latency metrics:
Min_Latency(ms): 145
Avg_Latency(ms): 2843
Max_Latency(ms): 3234
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 -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:  1042.90
MBs/sec:     2.03

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: 284338.93
MBs/sec:   555.34

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: 271342.86
MBs/sec:   529.96