Categories:
Cloud (204)
Entertainment (11)
Facebook (43)
General (50)
Life (31)
Programming (64)
Technology (398)
Testing (4)
Tools (488)
Twitter (5)
Wearable (26)
Web Design (44)
Collections:
Other Resources:
"sqlio -o" - Outstanding Tests in Asynchronous Queue
What is the Outstanding Tests in Asynchronous Queue option, "sqlio -o"?
✍: FYIcenter.com
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. In this case, all I/O tests are performed synchronously.
Example 1 - Run SQLIO with no tests in the Asynchronous Queue:
C:\fyicenter\SQLIO>sqlio -o0 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: 12155.57 MBs/sec: 23.74
Example 2 - Run SQLIO with 1 test in the Asynchronous Queue:
C:\fyicenter\SQLIO>sqlio -o1 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run enabling multiple I/Os per thread with 1 outstanding initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 12417.94 MBs/sec: 24.25
Example 3 - Run SQLIO with 2 tests in the Asynchronous Queue:
C:\fyicenter\SQLIO>sqlio -o2 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run enabling multiple I/Os per thread with 2 outstanding initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 19060.40 MBs/sec: 37.22
Example 4 - Run SQLIO with 4 test2 in the Asynchronous Queue:
C:\fyicenter\SQLIO>sqlio -o4 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run enabling multiple I/Os per thread with 4 outstanding initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 20579.95 MBs/sec: 40.19
As you can see, when staging more outstanding tests in the Asynchronous Queue, the throughput is getting better. It seems that the data storage has some capability to perform read operation parallelly with a single thread.
⇒ "sqlio -p" - CPU Number for Affinity
⇐ "sqlio -B" - Hardware/Software Buffering
2019-08-23, 836🔥, 0💬
Popular Posts:
How to use my iPhone and iPad to set up and manage Chromecast device on my TV? I have a Chromecast d...
How to download FrameMaker 2017 Release for my Windows computer? I want to try it. You can follow th...
Why am I not seeing the "Call Forwarding" option on Skype for Business on Windows? You don't see the...
What are the steps to insert Dynamic Fields in Microsoft Word? I want to insert the chapter heading ...
How to add a password to stop other people opening my Word document? I want share a Word file with m...