"sqlio -s" - Number of Seconds to Run

Q

What is the Number of Seconds to Run option, "sqlio -s"?

✍: FYIcenter.com

A

The number of Seconds to Run option, "sqlio -s", controls how long the test will run.

Example 1 - Run SQLIO for 30 seconds:

C:\fyicenter\SQLIO>sqlio -s30

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: 12514.80
MBs/sec:    24.44

Example 2 - Run SQLIO for 1 minute:

C:\fyicenter\SQLIO>sqlio -s60

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

In theory, if the environment is very stable, changing the Number of Seconds to Run option, "sqlio -s", should not impact the test result. But in most cases, there are many activities happening in your operating system and in your storage system, you need to run test long enough to average out the instability.

 

"sqlio -b" - IO Block Size in KB

"sqlio -L" - Latencies from System/Processor Timer

Getting Started with Microsoft SQLIO

⇑⇑ SQLIO Disk I/O Benchmark Test Tutorials

2019-08-19, 180👍, 0💬