Technology - SQLIO Disk I/O Benchmark Test Tutorials

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, 399👍, 0💬