
That way, I can find out if various parameters are faster or slower without reinstalling the OS.Īfter installing SQLIO, you won’t see anything in the Start menu because it doesn’t have a graphical user interface. I prefer installing it in C because I delete and recreate my non-system partitions repeatedly while I’m testing them. Install it in c:\Program Files no matter what drive you want to test. The support page doesn’t say Windows 2008, but it works fine.

It’s extremely lightweight – it takes less than 1MB on disk – and works on any version of Windows. Step 1: Download SQLIO from Microsoft for Freeĭownload SQLIO from Microsoft and install it on the Windows server you’d like to test. Whether you’re an Exchange guy, a SQL DBA, or a file & print fella, SQLIO will help you push your storage to the limit to see when it breaks. SQLIO has absolutely nothing to do with SQL Server – it’s just a tool to test IO.

It’s time to find out how fast your storage really is using SQLIO – perhaps the worst-named tool in history. They don’t tell you how fast (or slow) it is, they don’t know whether it meets your needs, and they probably don’t know where the bottlenecks are. Storage is a black box, right? The SAN admins ask how much storage space you need, you tell them, and then they give it to you.
