Was this page helpful?

SQLIO 測試

    內容表格
    沒有標頭
    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
    
    Was this page helpful?
    標籤 (Edit tags)
    • No tags
    您必須 登入 才能發佈評論。
    Powered by MindTouch Core