1 2 3 4 5 6 > >>   Sort: Rank

"sqlio -s" - Number of Seconds to Run
What is the Number of Seconds to Run option, "sqlio -s"? The number of Seconds to Run option, "sqlio -s", controls how long the test will run. Example 1 - Run SQLIO for 30 seconds: C:\fyicenter\SQLIO>sqli o-s30 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB strip...
2019-08-19, 123👍, 0💬

"sqlio -L" - Latencies from System/Processor Timer
What is the Latencies from System/Processor Timer option, "sqlio -L"? The Latencies from System/Processor Timer option, "sqlio -L", flags the test to include Latency measurements using the system timer or the process timer. Example 1 - Run SQLIO to include Latency measurements using the system timer...
2019-08-19, 122👍, 0💬

SQLIO Related Terminology
SQLIO Related Terminology: Affinity - Affinity refers to individual CPUs in a multi-CPU system. You can specify which single CPU to use by the "-p" option, or which group of CPUs to use by the "-a" option. Asynchronous Queue - SQLIO supports asynchronous I/O tests within a single thread You can cont...
2019-08-19, 122👍, 0💬

"sqlio -b" - IO Block Size in KB
What is the IO block size in KB option, "sqlio -b"? 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>sqli o-b4 1 thread reading ...
2019-08-19, 119👍, 0💬

Default Test with SQLIO
What is the default SQLIO test doing? If you run the "sqlio" command without any options, you are running the SQLIO default test, which is equivalent to: C:\fyicenter\SQLIO>sqli o-kR -t1 -s30 -f64 -b2 -i64 -BN testfile.dat Let's try it out: C:\fyicenter\SQLIO>sqli osqlio v1.5.SG 1 thre...
2019-08-19, 117👍, 0💬

I/O Tests on Flash Drives
Where to find SQLIO I/O Tests on Flash Drives, Thumb Drives, or Memory Sticks? Here is a list of SQLIO Test Result Summary on different Flash Drives, Thumb Drives, or Memory Sticks compiled by FYIcenter.com team. SanDisk Cruzer Blade Flash Drive - 64-KB Benchmark SanDisk Cruzer Blade Flash Drive - M...
2019-08-08, 136👍, 0💬

ST500DM002-1BD142 ATA HD - Maximum Reading Speed
What is maximum reading speed of the Seagate ST500DM002-1BD142 ATA HD? The best way to find out the maximum reading speed of your Seagate ST500DM002-1BD142 ATA HD is to run reading tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s30 -p0 ... If we run SQLIO with a...
2019-08-08, 136👍, 0💬

ST500DM002-1BD142 ATA HD - Maximum Writing Speed
What is maximum writing speed of the Seagate ST500DM002-1BD142 ATA HD? The best way to find out the maximum writing speed of your Seagate ST500DM002-1BD142 ATA HD is to run writing tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s30 -p0 ... If we run SQLIO with a...
2019-08-08, 132👍, 0💬

ST500DM002-1BD142 ATA HD - 64-KB Benchmark
What is the 64-KB I/O benchmark performance of Seagate ST500DM002-1BD142 ATA HD? The I/O performance of reading and writing 64-KB files of a Seagate ST500DM002-1BD142 ATA HD can be measured by running SQLIO with multiple 64-KB blocks with a large stripe factor. Here is the read performance test of S...
2019-08-08, 132👍, 0💬

ST500DM002-1BD142 ATA HD - 1-MB Benchmark
What is the 1-MB I/O performance of Seagate ST500DM002-1BD142 ATA HD on Azure VM? The I/O performance of reading and writing 1-MB files of a Seagate ST500DM002-1BD142 ATA HD can be measured by running SQLIO with multiple 1024-KB blocks with a large stripe factor. Here is the read performance test of...
2019-08-08, 130👍, 0💬

SanDisk Cruzer Blade Flash Drive - 64-KB Benchmark
What is the average I/O performance of SanDisk Cruzer Blade 32GB Flash Drive? The average I/O performance of a flash drive can be measured by running SQLIO with multiple 64-KB blocks with a large stripe factor. Here is the read performance test of SanDisk Cruzer Blade 32GB Flash Drive on 64-KB block...
2019-07-30, 140👍, 0💬

SanDisk Cruzer Micro Flash Drive - Maximum Reading Speed
What is maximum reading speed of the SanDisk Cruzer Micro 8GB Flash Drive? The best way to find out the maximum reading speed of your SanDisk Cruzer Micro 8GB Flash Drive is to run reading tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s60 -p0 ... If we run SQLI...
2019-07-30, 136👍, 0💬

SanDisk Cruzer Blade Flash Drive - Maximum Writing Speed
What is maximum writing speed of the SanDisk Cruzer Blade 32GB Flash Drive? The best way to find out the maximum writing speed of your SanDisk Cruzer Blade 32GB Flash Drive is to run writing tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s60 -p0 ... If we run SQ...
2019-07-30, 136👍, 0💬

SanDisk Cruzer Micro Flash Drive - 64-KB Benchmark
What is the average I/O performance of SanDisk Cruzer Micro 8GB Flash Drive? The average I/O performance of a flash drive can be measured by running SQLIO with multiple 64-KB blocks with a large stripe factor. Here is the read performance test of SanDisk Cruzer Micro 8GB Flash Drive on 64-KB blocks....
2019-07-30, 134👍, 0💬

SanDisk Cruzer Blade Flash Drive - Maximum Reading Speed
What is maximum reading speed of the SanDisk Cruzer Blade 32GB Flash Drive? The best way to find out the maximum reading speed of your SanDisk Cruzer Blade 32GB Flash Drive is to run reading tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s60 -p0 ... If we run SQ...
2019-07-30, 133👍, 0💬

PNY Attaché Flash Drive - Maximum Writing Speed
What is maximum writing speed of the PNY Attaché Flash Drive (256 MB capacity)? The best way to find out the maximum writing speed of your PNY Attaché Flash Drive is to run writing tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s60 -p0 ... If we run SQLIO with a...
2019-07-19, 149👍, 0💬

I/O Tests on Azure Virtual HD and Storage
Where to find SQLIO Tests on Azure Virtual HD and Storage Services? Here is a list of SQLIO Test Result Summary on different Azure Virtual HD and Storage Services compiled by FYIcenter.com team. Azure Virtual HD on Server 2016 - SQLIO Tests Virtual HD ATA Device on Server 2016 - 64-KB Benchmark Virt...
2019-07-19, 149👍, 0💬

SanDisk Cruzer Micro Flash Drive - Maximum Writing Speed
What is maximum writing speed of the SanDisk Cruzer Micro 8GB Flash Drive? The best way to find out the maximum writing speed of your SanDisk Cruzer Micro 8GB Flash Drive is to run writing tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s60 -p0 ... If we run SQLI...
2019-07-19, 148👍, 0💬

PNY Attaché Flash Drive - Maximum Reading Speed
What is maximum reading speed of the PNY Attaché Flash Drive (256 MB capacity)? The best way to find out the maximum reading speed of your PNY Attaché Flash Drive is to run reading tests with a single large block of different block sizes: sqlio -LS -kR -i1 -f1 -t1 -s60 -p0 ... If we run SQLIO with a...
2019-07-19, 148👍, 0💬

PNY Attaché Flash Drive - 64-KB Benchmark
What is the 64-KB I/O benchmark performance of PNY Attaché Flash Drive (256 MB capacity)? The I/O performance of reading and writing 64-KB files of a PNY Attaché Flash Drive (256 MB capacity) can be measured by running SQLIO with multiple 64-KB blocks with a large stripe factor. Here is the read per...
2019-07-19, 147👍, 0💬

Impact of Sharing Virtual HD with OS
What is the impact of sharing the Virtual HD storage device with the Windows OS on a virtual machine? If you are running a virtual machine with 2 Virtual HD storage devices, one is shared with Windows OS and the other is for applications, you can run two sets of SQLIO tests to see the impact of the ...
2019-07-09, 169👍, 0💬

Virtual HD ATA Device on Server 2016 - 64-KB Benchmark
What is the 64-KB I/O benchmark performance of Virtual HD ATA Device on Azure VM? The I/O performance of reading and writing 64-KB files of a Virtual HD ATA Device can be measured by running SQLIO with multiple 64-KB blocks with a large stripe factor. Here is the read performance test of Virtual HD ...
2019-07-09, 162👍, 0💬

Azure Virtual HD on Server 2016 - SQLIO Tests
How to test I/O performance on Azure Virtual HD on Windows Server 2016 with SQLIO? Azure Virtual HD on Windows 10 are virtual hard disk amounted on Windows Server 2016 VM offered as Azure cloud services. We tested Azure Virtual HD on Windows Server 2016 VM with SQLIO in two setups: "C:" drive which ...
2019-07-09, 160👍, 0💬

Virtual HD ATA Device on Server 2016 - 1-MB Benchmark
What is the 1-MB I/O performance of Virtual HD ATA Device on Azure VM? The I/O performance of reading and writing 1-MB files of a Virtual HD ATA Device can be measured by running SQLIO with multiple 1024-KB blocks with a large stripe factor. Here is the read performance test of Virtual HD ATA Device...
2019-07-09, 160👍, 0💬

1 2 3 4 5 6 > >>   Sort: Rank