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 -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, 430👍, 0💬
Popular Posts:
How to add ActiveX controls, like text command button, text box, check box, etc., to Presentation sl...
How to make my presentation beautiful by applying a built-in theme provided by Office PowerPoint 200...
How to create a macro in Microsoft Word? I want to learn how to do things in my Word document with V...
How to use my iPhone and iPad to set up and manage Chromecast device on my TV? I have a Chromecast d...
How to add more rows to a table in Microsoft Word documents? One quick way to add rows to a table is...