Was this page helpful?

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

     

    Was this page helpful?
    標籤 (Edit tags)
    • No tags
    您必須 登入 才能發佈評論。
    Powered by MindTouch Core