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 -i" - Number of IOs per IO Run
What is the Number of IOs per IO Run option, "sqlio -i"?
✍: FYIcenter.com
The Number of IOs per IO Run option, "sqlio -i",
specifies run size,
which is the number of I/O tests performed in each run.
The default value is "-i64", 64 tests per run. In this case, SQLIO will repeat as many as runs within the specified execution time. In each run, it will perform 64 I/O tests. Of course, each I/O test works on a single data block.
Example 1 - Run SQLIO with 16 tests per run:
C:\fyicenter\SQLIO>sqlio -i16 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 16 IOs per run initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 12361.34 MBs/sec: 24.14
Example 2 - Run SQLIO with 32 tests per run:
C:\fyicenter\SQLIO>sqlio -i32 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 32 IOs per run initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 4448.98 MBs/sec: 8.68
Example 2 - Run SQLIO with 64 tests per run:
C:\fyicenter\SQLIO>sqlio -i64 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
As you can see, when the run size is increased, the throughput goes down. This is because larger runs stretch out data file to be bigger, which takes longer for the operating system to handle.
⇒ "sqlio -t" - Number of Threads
⇐ "sqlio -f" - Stripe Size in Blocks
2019-09-04, 408👍, 0💬
Popular Posts:
How to install Microsoft Teams desktop version on Windows 7? I am tired of using Microsoft Teams Web...
How to add more rows to a table in Microsoft Word documents? One quick way to add rows to a table is...
What is "GoToMeeting Outlook COM Addin" in Microsoft Word? Should I disable it? "GoToMeeting Outlook...
Where to find answers to frequently asked questions on installing and using Mozilla Firefox 2.0? Her...
How to install Mozilla Firefox 2.0 add-on: FireFTP? FireFTP is a Mozilla Firefox 2 add-on that provi...