<< < 1 2 3 4 5 6 7 8 > >>   Sort: Rank

"sqlio -B" - Hardware/Software Buffering
What is the Hardware/Software Buffering option, "sqlio -B"? 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 bu...
2019-09-04, 284👍, 0💬

"sqlio -kR -b1024" - Reading 1-MB Block Test
How to perform tests for reading 1 MB files? I want to see the impact of file size on reading files. If you want to see the impact of file size on reading files, try to increase the block size from 64 KB to 1024 KB (1 MB), and keep the other options unchanged: C:\fyicenter\SQLIO&gt;sqli o-LS -kR...
2019-09-04, 276👍, 0💬

"sqlio -kR -b64" - Reading 64-KB Block Test
How to perform tests for reading 64 KB files? My Website serves picture files with an average of 64 KB per file. If you want to know how your environment performs on reading 64 KB files, you can use the following SQLIO options: "-LS" - Sets SQLIO to report latency measurements using the system timer...
2019-08-23, 294👍, 0💬

"sqlio -kW -b64" - Writing 64-KB Block Test
How to perform tests for writing 64 KB files? My Website allows users to upload picture files with an average of 64 KB per file. If you want to know how your environment performs on writing 64 KB files, you can use the following SQLIO options: "-LS" - Sets SQLIO to report latency measurements using ...
2019-08-23, 288👍, 0💬

"sqlio -o" - Outstanding Tests in Asynchronous Queue
What is the Outstanding Tests in Asynchronous Queue option, "sqlio -o"? The Outstanding Tests in Asynchronous Queue option, "sqlio -o", specifies the number of I/O tests to be staged in the Outstanding Asynchronous Queue. The default value is "-o0", no Outstanding I/O tests in the Asynchronous Queue...
2019-08-23, 284👍, 0💬

Windows Resource Monitor - Disk Writing Speed
How to watch the disk writing speed on Windows Resource Monitor? You can follow this tutorial to watch disk writing speed on Windows Resource Monitor. 1. Re-run the SQLIO command to perform a disk writing test: C:\fyicenter\SQLIO&gt;sqli o-LS -kW -b64 -i64 -f64 -t1 -s300 1 thread writing for 300...
2019-08-23, 281👍, 0💬

Windows Resource Monitor - Disk Reading Speed
How to watch the disk reading speed on Windows Resource Monitor? You can follow this tutorial to watch disk reading speed on Windows Resource Monitor. 1. Re-run the SQLIO command to perform a disk reading test: C:\fyicenter\SQLIO&gt;sqli o-LS -kR -b64 -i64 -f64 -t1 -s300 1 thread reading for 300...
2019-08-23, 265👍, 0💬

"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&gt;sqli o-s30 1 thread reading for 30 secs from file testfile.dat using 2KB IOs over 128KB strip...
2019-08-19, 281👍, 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&gt;sqli o-kR -t1 -s30 -f64 -b2 -i64 -BN testfile.dat Let's try it out: C:\fyicenter\SQLIO&gt;sqli osqlio v1.5.SG 1 thre...
2019-08-19, 280👍, 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, 275👍, 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, 273👍, 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&gt;sqli o-b4 1 thread reading ...
2019-08-19, 270👍, 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, 299👍, 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, 287👍, 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, 274👍, 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, 250👍, 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, 248👍, 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, 273👍, 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, 269👍, 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, 268👍, 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, 266👍, 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, 256👍, 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, 269👍, 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, 261👍, 0💬

<< < 1 2 3 4 5 6 7 8 > >>   Sort: Rank