"sqlio -k" - Kind of I/O

Q

What is the Kind of I/O option, "sqlio -k"?

✍: FYIcenter.com

A

The Kind of I/O option, "sqlio -k", specifies what kind of I/O to test, reading or writing.

The default value is "-kR", reading I/O test.

Example 1 - Run SQLIO for reading I/O testing:

C:\fyicenter\SQLIO>sqlio -kR

1 thread reading for 30 secs from file testfile.dat
        using 2KB IOs over 128KB stripes with 64 IOs per run
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:  3080.69
MBs/sec:     6.01

Example 1 - Run SQLIO for writing I/O testing:

C:\fyicenter\SQLIO>sqlio -kW

1 thread writing for 30 secs to file testfile.dat
        using 2KB IOs over 128KB stripes with 64 IOs per run
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec:  1277.07
MBs/sec:     2.49

As you can see, reading is faster than writing as we expected, so reading has a higher throughput.

 

"sqlio E:\testfile.dat" - Test on USB Drive

"sqlio -a" - CPU Mask for Affinity

Getting Started with Microsoft SQLIO

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-05-14, 182👍, 0💬