SQLIO Stress Test Tool

Question

SQLIO Stress Test Tool

homebrew01

SSC Guru

Points: 55548
More actions
January 10, 2009 at 6:58 pm

#129957

Any thoughts on using this on a SQL box while setting up a VM SAN environment ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

It is a good way to find your IO capacity. If you are just starting out, you might use it to play with varying configurations of your SAN and offsets of your VMDK's and VM OS's to make sure that you are building an optimal configuration.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 2

It's a good and simple tool, but you have to know how to use it.

Here are two useful articles:

http://www.sqlteam.com/article/benchmarking-disk-io-performance-size-matters

http://sqlblog.com/blogs/linchi_shea/archive/2007/02/21/parse-the-sqlio-exe-output.aspx

[font="Verdana"]Markus Bohse[/font]

george sibbald SSC Guru Points: 104210 More actions · Answer 3

If you are asking is it worthwhile using this tool then yes it is.

If this application is already up and running on an existing server and you plan to migrate run sysmons on the existing server to give you a good idea of the prevailing I/O patterns so you know what block sizes to test.

BTW despite the name SQLIO is a tool for testing various IO patterns and is not specifically for SQL, use SQLIOSim as well to stress test the server under a typical SQL load.

---------------------------------------------------------------------