SQLIO Disk I/O Benchmark Test Tutorials

Q

Where to find answers for frequently asked questions (FAQ) on Microsoft SQLIO - Disk Subsystem Benchmark Tool?

✍: FYIcenter.com

A

Here is a collection of many frequently asked questions on Microsoft SQLIO - Disk Subsystem Benchmark Tool with answers compiled by FYIcenter.com team:

Getting Started with Microsoft SQLIO

What Is SQLIO

Download and Install SQLIO

SQLIO Command Line Options

Default Test with SQLIO

SQLIO Related Terminology

"sqlio -L" - Latencies from System/Processor Timer

"sqlio -s" - Number of Seconds to Run

"sqlio -b" - IO Block Size in KB

"sqlio -f" - Stripe Size in Blocks

"sqlio -i" - Number of IOs per IO Run

"sqlio -t" - Number of Threads

"sqlio -B" - Hardware/Software Buffering

"sqlio -o" - Outstanding Tests in Asynchronous Queue

"sqlio -p" - CPU Number for Affinity

"sqlio -a" - CPU Mask for Affinity

"sqlio -k" - Kind of I/O

"sqlio E:\testfile.dat" - Test on USB Drive

Tuning SQLIO for Your Environment

"sqlio -s300" - Get Stable Test Result

"sqlio -kR -b64" - Reading 64-KB Block Test

Windows Resource Monitor - Disk Reading Speed

"sqlio -kW -b64" - Writing 64-KB Block Test

Windows Resource Monitor - Disk Writing Speed

"sqlio -kR -b1024" - Reading 1-MB Block Test

"sqlio -kW -b1024" - Writing 1-MB Block Test

Western Digital - WD5000LPLX-08ZNT - Maximum Reading Speed

Western Digital - WD5000LPLX-08ZNT - Maximum Writing Speed

I/O Tests on Solid State Disk (SDD)

INTEL SSDPEKKF256G8L - SQLIO Tests

INTEL SSDPEKKF256G8L SSD - 64-KB Benchmark

INTEL SSDPEKKF256G8L SSD - 1-MB Benchmark

INTEL SSDPEKKF256G8L SSD - Maximum Reading Speed

INTEL SSDPEKKF256G8L SSD - Maximum Writing Speed

I/O Tests on Hard Disks (HD)

ST500DM002-1BD142 ATA HD - SQLIO Tests

ST500DM002-1BD142 ATA HD - 64-KB Benchmark

ST500DM002-1BD142 ATA HD - 1-MB Benchmark

ST500DM002-1BD142 ATA HD - Maximum Reading Speed

ST500DM002-1BD142 ATA HD - Maximum Writing Speed

I/O Tests on Flash Drives

SanDisk Cruzer Blade Flash Drive - 64-KB Benchmark

SanDisk Cruzer Blade Flash Drive - Maximum Reading Speed

SanDisk Cruzer Blade Flash Drive - Maximum Writing Speed

SanDisk Cruzer Micro Flash Drive - 64-KB Benchmark

SanDisk Cruzer Micro Flash Drive - Maximum Reading Speed

SanDisk Cruzer Micro Flash Drive - Maximum Writing Speed

Kingston DataTraveler 101 Flash Drive - 64-KB Benchmark

Kingston DataTraveler 101 Flash Drive - Maximum Reading Speed

Kingston DataTraveler 101 Flash Drive - Maximum Writing Speed

PNY Attaché Flash Drive - 64-KB Benchmark

PNY Attaché Flash Drive - Maximum Reading Speed

PNY Attaché Flash Drive - Maximum Writing Speed

I/O Tests on Azure Virtual HD and Storage

Azure Virtual HD on Server 2016 - SQLIO Tests

Virtual HD ATA Device on Server 2016 - 64-KB Benchmark

Virtual HD ATA Device on Server 2016 - 1-MB Benchmark

Impact of Sharing Virtual HD with OS

Azure Virtual HD on Windows 10 - SQLIO Tests

Azure Virtual HD on Windows 10 as C: - 64-KB Benchmark

Azure Virtual HD on Windows 10 as C: - 1-MB Benchmark

Azure Virtual HD on Windows 10 as C: - Maximum Reading Speed

Azure Virtual HD on Windows 10 as C: - Maximum Writing Speed

Azure Virtual HD on Windows 10 as D: - 64-KB Benchmark

Azure Virtual HD on Windows 10 as D: - 1-MB Benchmark

Azure Virtual HD on Windows 10 as D: - Maximum Reading Speed

Azure Virtual HD on Windows 10 as D: - Maximum Writing Speed

SQLIO Test Result Summary

Hard Disk Brand and Model

Storage Device Types and Models Tested

Storage Device Benchmark Performance

Storage Device Maximum Speed Summary

 

Getting Started with Microsoft SQLIO

2019-05-10, 235👍, 0💬