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 -b" - IO Block Size in KB
What is the IO block size in KB option, "sqlio -b"?
✍: FYIcenter.com
The IO block size in KB option, "sqlio -b",
controls the size of each data block used as a unit for each I/O test.
The default value is "-b2", 2KB.
Example 1 - Run SQLIO with 4KB per data block:
C:\fyicenter\SQLIO>sqlio -b4 1 thread reading for 30 secs from file testfile.dat using 4KB IOs over 256KB stripes with 64 IOs per run initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 3729.90 MBs/sec: 14.56
Example 2 - Run SQLIO with 8KB per data block:
C:\fyicenter\SQLIO>sqlio -b8 1 thread reading for 30 secs from file testfile.dat using 8KB IOs over 512KB stripes with 64 IOs per run initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 407.44 MBs/sec: 3.18
Example 3 - Run SQLIO with 16KB per data block:
C:\fyicenter\SQLIO>sqlio -b16 -LS 1 thread reading for 30 secs from file testfile.dat using 16KB IOs over 1024KB stripes with 64 IOs per run initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 156.40 MBs/sec: 2.44
As you can see, reading a larger block takes longer time as we expected. The throughput goes down means that each block is taking longer to finish.
⇒ "sqlio -f" - Stripe Size in Blocks
⇐ "sqlio -s" - Number of Seconds to Run
2019-08-19, 386👍, 0💬
Popular Posts:
What is a slide master in PowerPoint? A slide master is a set of slide layouts defined to help you c...
How to unzip a PowerPoint .pptx file? According to Microsoft documentation, a .pptx file is really a...
How to create a new WeChat account with my Facebook account? Creating a new WeChat account with a Fa...
What is this Website about? This Website provides a collection of Frequently Asked Questions (FAQ) a...
What browser to use to cast Website and video to Chromecast devices on my Android phone? On your And...