首页 > 代码库 > SQLIO Disk Subsystem Benchmark Tool
SQLIO Disk Subsystem Benchmark Tool
C:\Program Files (x86)\SQLIO>sqlio -?sqlio v1.5.SG-?: invalid optionUsage: sqlio [options] [<filename>...] [options] may include any of the following: -k<R|W> kind of IO (R=reads, W=writes) -t<threads> number of threads -s<secs> number of seconds to run -d<drv_A><drv_B>.. use same filename on each drive letter given -R<drv_A/0>,<drv_B/1>.. raw drive letters/number for I/O -f<stripe factor> stripe size in blocks, random, or sequential -p[I]<cpu affinity> cpu number for affinity (0 based)(I=ideal) -a[R[I]]<cpu mask> cpu mask for (R=roundrobin (I=ideal)) affinity -o<#outstanding> depth to use for completion routines -b<io size(KB)> IO block size in KB -i<#IOs/run> number of IOs per IO run -m<[C|S]><#sub-blks> do multi blk IO (C=copy, S=scatter/gather) -L<[S|P][i|]> latencies from (S=system, P=processor) timer -B<[N|Y|H|S]> set buffering (N=none, Y=all, H=hdwr, S=sfwr) -S<#blocks> start I/Os #blocks into file -v1.1.1 I/Os runs use same blocks, as in version 1.1.1 -F<paramfile> read parameters from <paramfile>Defaults: -kR -t1 -s30 -f64 -b2 -i64 -BN testfile.datMaximums: -t (threads): 256 no. of files, includes -d & -R: 256 filename length: 256C:\Program Files (x86)\SQLIO>
参数 –kW 表示模拟写的情况,如果是-kR则表示写;
参数 –t2 表示两个线程
参数 –s120表示测试2分钟
参数 –dM 表示具体的盘符
参数 –o1表示outstanding IO的数目
参数 –frandom表示随机模式,相反的是sequential 序列模式
参数 –b64 表示每个IO大小为64K
1 sqlio -kW -t2 -s120 -dM -o1 -frandom -b64 -BH -LS Testfile.dat2 sqlio -kW -t2 -s120 -dM -o2 -frandom -b64 -BH -LS Testfile.dat3 sqlio -kW -t2 -s120 -dM -o4 -frandom -b64 -BH -LS Testfile.dat4 sqlio -kW -t2 -s120 -dM -o8 -frandom -b64 -BH -LS Testfile.dat
需要到以下地址下载
http://www.microsoft.com/en-us/download/details.aspx?id=20163
I/O 特性
操作 | 随机/顺序 | 读/写 | 大小范围 |
Create Database | 顺序 | 写 | 512KB |
Backup Database | 顺序 | 读/写 | 64KB的倍数(最多4MB) |
Restore Database | 顺序 | 读/写 | 64KB的倍数(最多4MB) |
DBCC-CHECKDB | 顺序 | 读 | 8KB~64KB |
Alter Index - on - rebuild (读阶段) | 顺序 | 读 |
|
Alter Index - on - rebuild (写阶段) | 随机或顺序 | 写 | 8KB的背书,最多128KB |
Sys.dm_db_index_phyical_stats http://technet.microsoft.com/zh-cn/library/ms181929.aspx | 顺序 | 读 | 8KB~64KB |
INSERT/UPDATE/DELETE | 随机或顺序 | 写 | 64KB~512KB |
SELECT | 随机或顺序 | 读 | 51KB~5124KB |
TempDB | 随机或顺序 | 读/写 | 8KB~64KB |
事务日志 | 顺序 | 写 | 60KB |
http://technet.microsoft.com/en-us/library/cc966412.aspx
SQLIO Disk Subsystem Benchmark Tool