Categories:
Cloud (163)
Entertainment (11)
Facebook (43)
General (17)
Life (30)
Programming (33)
Technology (249)
Testing (4)
Tools (448)
Twitter (5)
Wearable (26)
Web Design (9)
Collections:
Other Resources:
"sqlio -t" - Number of Threads
What is the Number of Threads option, "sqlio -t"?
✍: FYIcenter.com
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 blocking among threads.
Example 1 - Run SQLIO with 1 thread:
C:\fyicenter\SQLIO>sqlio -t1 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: 2890.22 MBs/sec: 5.64
Example 2 - Run SQLIO with 2 threads:
C:\fyicenter\SQLIO>..\sqlio -t2 2 threads 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: 17921.66 MBs/sec: 35.00
Example 3 - Run SQLIO with 4 threads:
C:\fyicenter\SQLIO>..\sqlio -t4 4 threads 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: 20581.05 MBs/sec: 40.19
As you can see, when more threads are used, the throughput goes up, because more I/O tests can be performed with more threads running.
⇒ "sqlio -B" - Hardware/Software Buffering
⇐ "sqlio -i" - Number of IOs per IO Run
2019-09-04, 470👍, 0💬
Popular Posts:
Why I getting the "Error! No text of specified style in document." in Microsoft Word? You are gettin...
How to configure Mozilla Firefox to use Notepad to edit Web page source code? By default, when you u...
How to save a presentation with macros in the PowerPoint Macro-Enabled Presentation (*.pptm) file fo...
Why am I not seeing the "Call Forwarding" option on Skype for Business on Windows? You don't see the...
What is this Website about? This Website provides a collection of Frequently Asked Questions (FAQ) a...