SQLIO Disk Test Tool reference

SQLIO: SQLIO Disk Subsystem Benchmark Tool

default directory: C:\Program Files\sqlio

Run as command line, go to the installation directory (C:\Program Files\sqlio) run SQLIO perform the test

#常用参数

OTHE-K option to specify the I/O operation type (read or write) othe-s option to specify the test duration in seconds oTh E-F option to specify the type of I/O access (sequential or random) othe-o option to specify the number of outstanding re Quests  othe-b option to specify the size of the I/O request in bytesblock sizeothe-ls option to capture the disk lat Ency optionothe-f option to specify the name of the file which contain the test files to run SQLIO against

#测试参考

Sqlio-kw-s300-frandom-o32-b4-ls-fparam.txtsqlio-kr-s300-frandom-o32-b4-ls-fparam.txtsqlio-kw-s300-fsequen Tial-o32-b4-ls-fparam.txtsqlio-kr-s300-fsequential-o32-b4-ls-fparam.txtsqlio-kw-s300-frandom-o32-b8-ls-f PARAM.TXTSQLIO-KR-S300-FRANDOM-O32-B8-LS-FPARAM.TXTSQLIO-KW-S300-FSEQUENTIAL-O32-B8-LS-FPARAM.TXTSQLIO-KR- S300-fsequential-o32-b8-ls-fparam.txtsqlio-kw-s300-frandom-o32-b64-ls-fparam.txtsqlio-kr-s300-frandom-o32 -b64-ls-fparam.txtsqlio-kw-s300-fsequential-o32-b64-ls-fparam.txtsqlio-kr-s300-fsequential-o32-b64-ls-fpar Am.txtsqlio-kw-s300-frandom-o32-b128-ls-fparam.txtsqlio-kr-s300-frandom-o32-b128-ls-fparam.txtsqlio-kw-s30 0-fsequential-o32-b128-ls-fparam.txtsqlio-kr-s300-fsequential-o32-b128-ls-fparam.txt

The following files and their contents are created under the installation directory using the command line batch execution

#结果输出文件:result.txt

#参数文件 (4 thread 10GB):param.txt

D:\sqliotestfile.dat 4 0x0 10000

#bat批量执行文件:Executecmd.bat

echo----------------------------sqlio-kw-s300-frandom-o32-b4-ls-fparam.txt----------------------->> Result.txtecho. >>result.txtsqlio-kw-s300-frandom-o32-b4-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kr-s300-frandom-o32-b4-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kr-s300-frandom-o32-b4-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-fsequential-o32-b4-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-fsequential-o32-b4-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kr-s300-fsequential-o32-b4-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kr-s300-fsequential-o32-b4-ls-fparam.txt&gT;>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-frandom-o32-b8-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-frandom-o32-b8-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kr-s300-frandom-o32-b8-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kr-s300-frandom-o32-b8-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-fsequential-o32-b8-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-fsequential-o32-b8-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kr-s300-fsequential-o32-b8-ls- Fparam.txt----------------------->>result.txtecho. >>rEsult.txtsqlio-kr-s300-fsequential-o32-b8-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-frandom-o32-b64-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-frandom-o32-b64-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kr-s300-frandom-o32-b64-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kr-s300-frandom-o32-b64-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-fsequential-o32-b64-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-fsequential-o32-b64-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------sqlio-kr-s300-fsequential-o32-b64-ls-fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kr-s300-fsequential-o32-b64-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-frandom-o32-b128-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-frandom-o32-b128-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kr-s300-frandom-o32-b128-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kr-s300-frandom-o32-b128-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>result.txtecho----------------------------Sqlio-kw-s300-fsequential-o32-b128-ls- Fparam.txt----------------------->>result.txtecho. >>result.txtsqlio-kw-s300-fsequential-o32-b128-ls-fparam.txt>>result.txtecho. >>result.txtecho. >>resuLt.txtecho----------------------------Sqlio-kr-s300-fsequential-o32-b128-ls-fparam.txt----------------------- >>result.txtecho. >>result.txtsqlio-kr-s300-fsequential-o32-b128-ls-fparam.txt>>result.txt

More detailed parameters:

Option	Description
-K	-k<r| w> Specifies the kind of test I/O: Read or write -KR Test Read -KW Test Write
- S	-s<secs> Specifies the test execution time, in seconds -S360 Test 360 seconds It is usually recommended to run for 5-10 minutes to get more reasonable results.
-F	-f<stripe factor> specifying I/O strip test mode -fsequential using sequential mode -frandom using random methods -f8 stripesize = 8 * (-B parameter) The stripe (Stripe) represents the smallest partition in the disk.
-O	-o< #outstanding > Specifies the number of unhandled I/O requests, that is, the depth of the request Queue -o8 8 Outstanding I/O requests per Queue By specifying different values to change the overall throughput rate, the common values are 8, 32, 64.
-B	-b<size (KB) > Specify the size of the I/O request block, Unit Kbytes -b8 using a request block size of 8 Kbytes
-L	-l<s| P> Specifying capture delay information -ls delay information from system counter S = Systems Timer -lp delay information from processor counter P = Processor Timer
-T	-t<threads> the number of specified threads, maximum value 256 -t8 using 8 Threads for testing
-B	-b<n| y| h| S> set Cache (buffering) -bn N=none -by Y=all -BH H=hdwr -bs S=SFWR
-F	-f<paramfile> Specify test parameter file location, file name maximum length 256 -fparam.txt reading parameters from the Param.txt file in the current running directory
-D	-d<driveletter> Specifies the test disk drive, specifying a maximum of 256 drive letters -DD Test D-plate -dde Test D and E-trays
-P	-p<i> Specifying CPU Affinity -P0 affinity on CPU number 0 -pi0 ideal affinity on CPU number 0 CPU Affinity is allowed to run on a specific processor.
-A	-a<r| I> specifying the CPU Affinity mask -a3 Affnity Mask is 0x3 (3) -AR3 affinity Mask is 0x3 (3) with round robin -ari3 Ideal affinity mask is 0x3 (3) with round robin
-I.	-i< #IO/run> Specify the number of IO to be executed per IO test -i8 8 IOs per run
-M	-m<[c| s]>< #sub-blks> do multi blk IO (c=copy, S=scatter/gather)
-S	-s< #blocks > Start I/O #blocks into file

Reference Document: Performance Guidance for SQL Server in Windows Azure Virtual machines

SQLIO Disk Test Tool reference