"sqlio E:\testfile.dat" - Test on USB Drive
How to perform I/O tests for the USB drive?
You can specify a file name with the USB drive letter to perform I/O test for the USB device.
1. Insert your USB drive, and check for its drive letter, like "E:".
2. Run SQLIO with a 1 MB data file on the USB drive:
C:\files\SQLIO\test>..\sqlio -b4 -f16 -i16 E:\test.dat 1 thread reading for 30 secs from file E:\test.dat using 4KB IOs over 64KB stripes with 16 IOs per run size of file E:\test.dat needs to be: 1048576 bytes current file size: 0 bytes need to expand by: 1048576 bytes expanding E:\test.dat ... done. initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 893.46 MBs/sec: 3.49
3. Run the same test on the hard disk drive:
C:\files\SQLIO\test>..\sqlio -b4 -f16 -i16 C:\files\SQLIO\test.dat 1 thread reading for 30 secs from file test.dat using 4KB IOs over 64KB stripes with 16 IOs per run size of file test.dat needs to be: 1048576 bytes current file size: 8192 bytes need to expand by: 1040384 bytes expanding test.dat ... done. initialization done CUMULATIVE DATA: throughput metrics: IOs/sec: 11528.48 MBs/sec: 45.03
As you can see, reading data from the hard disk is about 15 times faster than reading data from the USB drive.
2019-05-14, 163👍, 0💬
How to create a command button to run my macro in slide show in PowerPoint? I have created a macro t...
What is a slide master in PowerPoint? A slide master is a set of slide layouts defined to help you c...
How to pause file transfer in FileZilla FTP Client? I want to close the computer in the middle of a ...
Where to find answers to frequently asked questions in general understanding of Microsoft Office 365...
What are Control Connection and Data Connection used in FTP protocol? FTP protocol uses two independ...