What is SQLIO Writing

SQLIO is a great tool for testing your disk subsystem, measuring straight IOPS, MB/sec, etc. Setting it up and getting it working is not that hard. The question is, what is it writing? By default, most tests show how to set up a file filled with '0' and then you point the executable at that file, which should be on the drive you're testing in order to have the test run. The question is, is it reading from the file in order to write to it? Or is it writing what it wants, probably '0'?

more ▼

asked Jun 17, 2011 at 10:54 AM in Default

avatar image

Grant Fritchey ♦♦
137k 20 46 81

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Interesting question having played with SQLIO quite a bit.

From my understanding/observations the tool pre-fills a file, or uses an existing one. The reads and writes are separate functionality tests and don't match up in a one-to-one relationship.

Whatever is read in is discarded, and output is from RAM in the pre-defined slot size. What is being written is not so important as the size and method (sequential or random). The important thing is that bytes are being transferred - the tool doesn't test for bit-flipping and data consistency, it tests for raw data movement.

The actual data being 0's lets the file be compressed to almost nothing if need be.

more ▼

answered Jun 17, 2011 at 12:51 PM

avatar image

12.1k 30 36 42

And that's the problem. Compression goes right down to zero, so you don't get a valid test of writes if you have a compression filter running. Nuts.

That squares with everything else I've seen so far. Thanks.

Jun 17, 2011 at 02:42 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 17, 2011 at 10:54 AM

Seen: 1827 times

Last Updated: Jun 17, 2011 at 10:54 AM

Copyright 2018 Redgate Software. Privacy Policy