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 -B" - Hardware/Software Buffering
What is the Hardware/Software Buffering option, "sqlio -B"?
✍: FYIcenter.com
The Hardware/Software Buffering option, "sqlio -B", specifies the buggering mode, "-BN" to turn off buffering, "-BY" to turn on both hardware and software buffering, "-BH" to turn on hardware buffering only, and "-BH" to turn on software buffering only.
The default value is "-BN", no buffering.
Example 1 - Run SQLIO with no buffering:
C:\fyicenter\SQLIO>sqlio -BN 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 software buffering only:
C:\fyicenter\SQLIO>sqlio -BS 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run buffering set to use software file cache (but not disk cache) initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 186665.78 MBs/sec: 364.58
Example 2 - Run SQLIO with hardware buffering only:
C:\fyicenter\SQLIO>sqlio -BH 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run buffering set to use hardware disk cache (but not file cache) initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 12483.85 MBs/sec: 24.38
Example 2 - Run SQLIO with hardware buffering only:
C:\fyicenter\SQLIO>sqlio -BY 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB stripes with 64 IOs per run buffering set to use both file and disk caches initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 189066.10 MBs/sec: 369.26 C:\fyicenter\SQLIO>
As you can see, when more threads are used, buffering helps a lot on the throughput for reading data as we expected.
⇒ "sqlio -o" - Outstanding Tests in Asynchronous Queue
⇐ "sqlio -t" - Number of Threads
2019-09-04, 840🔥, 0💬
Popular Posts:
How to download Mozilla Firefox 2.0? If you want to try Mozilla Firefox 2.0, you can follow this tut...
How to add page number in the footer area of each page in Microsoft Word? The quickest way to add pa...
How to add a new layout to the slide master in PowerPoint? In my PowerPoint presentation, I need to ...
How to add page number in the footer area of each page in Microsoft Word? The quickest way to add pa...
How to edit Mozilla Firefox configuration file? Mozilla Firefox has a configuration file that contro...