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 -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, 840🔥, 0💬
Popular Posts:
Why I am getting the "FTP over TLS is not enabled, users cannot securely log in" waring on my FileZi...
How to create a command button to run my macro in slide show in PowerPoint? I have created a macro t...
What is TestReail? TestRail is a comprehensive web-based test case management software to efficientl...
How to add comments on slides? I am reviewing someone else's presentation and I want to add some com...
Why I am getting the "Account Frozen" message when login to OneDrive? If you have not used your free...