Categories:
Cloud (161)
Entertainment (11)
Facebook (43)
General (16)
Life (30)
Programming (33)
Technology (224)
Testing (4)
Tools (431)
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, 409👍, 0💬
Popular Posts:
How to draw a diagram on a PowerPoint slide? You can easily draw a diagram on any PowerPoint slide i...
How to create two columns in Microsoft Word documents? If you want to make a part of a Word document...
How to make my presentation beautiful by applying a built-in theme provided by Office PowerPoint 200...
What contents are stored in a Web Archive (.mht) file? When you convert a word document into a singl...
Where does Mozilla Firefox 2 store download files? When you download files from Websites, Mozilla Fi...