Microsoft has released a free tool - SQLIO (Download at http://www.microsoft.com/en-us/download/details.aspx?id=20163 ) Intel initially has developed IOMeter which is now open source can be download at http://www.iometer.org/doc/downloads.html Both tools are pretty easy to use. Of course, SQLIO provide more advance testing scenario by choosing the right parameter, such as number to threads, file size, read/write, random/sequential, block size, buffer cache, etc... I've seen 2 good sites that explain pretty well with SQLIO command... pls see... http://www.mssqltips.com/sqlservertip/2127/benchmarking-sql-server-io-with-sqlio/ http://www.sqlteam.com/article/benchmarking-disk-io-performance-size-matters However, I still no no idea what's the actual number we should be look at... I created the batch file as shown below. @echo off cls :start echo Testing IO... SQLIO.exe -kW -s60 -frandom -o8 -b8 -LS -Fparam.txt timeout /T 60 SQLIO.exe -kW -s60 -frandom -o8 -b256 -
This is meant for educational purpose.