"sqlio -k" - Kind of I/O

Home > Technology

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, 1262🔥, 0💬

"sqlio -kR -b64" - Reading 64-KB Block Test
How to perform tests for reading 64 KB files? My Website serves picture files with an average of 64 KB per file. If you want to know how your environment performs on reading 64 KB files, you can use the following SQLIO options: "-LS" - Sets SQLIO to report latency measurements using the system timer... 2019-08-23, ∼1358🔥, 0💬

"sqlio -a" - CPU Mask for Affinity
What is the CPU Mask for Affinity option, "sqlio -p"? The CPU Mask for Affinity option, "sqlio -p", specifies a group of CPUs, using a binary number to mask them, to run SQLIO. The default value is "", all CPUs. In this case, all CPUs are used. Example 1 - Run SQLIO with the first CPU, 8 = 0x8 = 0b1... 2019-05-14, ∼1348🔥, 0💬

"sqlio -t" - Number of Threads
What is the Number of Threads option, "sqlio -t"? The Number of Threads option, "sqlio -t", specifies how many threads to use to perform test runs. The default value is "-t1", 1 thread only. In this case, test runs are performed sequentially, there shouldn't be any performance impact on data blockin... 2019-09-04, ∼1307🔥, 0💬

"sqlio E:\testfile.dat" - Test on USB Drive
How to perform I/O tests for the USB drive? You can specify a file name with the USB drive letter to perform I/O test for the USB device. 1. Insert your USB drive, and check for its drive letter, like "E:". 2. Run SQLIO with a 1 MB data file on the USB drive: C:\files\SQLIO\test>..\ sqlio-b4 ... 2019-05-14, ∼1296🔥, 0💬

Tuning SQLIO for Your Environment
Where to find tutorials on Tuning SQLIO Tests for Your Environment? Here is a list of tutorials to answer many frequently asked questions compiled by FYIcenter.com team on Tuning SQLIO Tests for Your Environment. "sqlio -s300" - Get Stable Test Result "sqlio -kR -b64" - Reading 64-KB Block Test Wind... 2019-05-14, ∼1280🔥, 0💬

"sqlio -o" - Outstanding Tests in Asynchronous Queue
What is the Outstanding Tests in Asynchronous Queue option, "sqlio -o"? The Outstanding Tests in Asynchronous Queue option, "sqlio -o", specifies the number of I/O tests to be staged in the Outstanding Asynchronous Queue. The default value is "-o0", no Outstanding I/O tests in the Asynchronous Queue... 2019-08-23, ∼1264🔥, 0💬

"sqlio -k" - Kind of I/O
What is the Kind of I/O option, "sqlio -k"? 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>sqli o-kR 1 thread reading for 30 secs from f... 2019-05-14, ∼1263🔥, 0💬

"sqlio -B" - Hardware/Software Buffering
What is the Hardware/Software Buffering option, "sqlio -B"? The Hardware/Software Buffering option, "sqlio -B", specifies the buggering mode, "-BN" to turn off buffering, "-BY" to turn on both hardware and software buffering, "-BH" to turn on hardware buffering only, and "-BH" to turn on software bu... 2019-09-04, ∼1262🔥, 0💬

"sqlio -p" - CPU Number for Affinity
What is the CPU Number for Affinity option, "sqlio -p"? The CPU Number for Affinity option, "sqlio -p", specifies a specific CPU to run SQLIO. The default value is "", all CPUs. In this case, all CPUs are used. Example 1 - Run SQLIO with the first CPU: C:\fyicenter\SQLIO>sqli o-p0 1 thread re... 2019-05-14, ∼1221🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.