設定同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
Images 0 | ||
---|---|---|
No images to display in the gallery. |