SQLIOSim simulating SQL Server behavior to test IO performance

SQLIOSim

Function:

Simulates the behavior of SQL Server to test IO performance.

Version of SQLIOSim:

(1) SQL Server 2005 SQLIOSim is a suite that needs to be downloaded online.

(2) Starting with SQL Server 2008, SQLIOSim is included in the SQL Sever installation. For SQL Server R2, the application is in the same directory as C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\binn.

(3) SQLIOSim will replace Sqliostress;sqliostress previously known as SQL70IOStress.

(4) SQLIOSim compared to SQLIOStress to simulate the disk I/O mode of SQL Server more accurately.

SQLIOSim Main Features:

(1) Use this tool to perform reliability and security testing on disk subsystems.

(2) These tests simulate the activities of SQL Server, such as read, write, checkpoint, backup, sort, pre-read, and so on.

Usage Environment:

(1) SQL Server can be installed without prior view.

(2) Suitable for simulating disk I/O patterns that generate SQL Server.

Description of the relevant documents:

(1) SQLIOSIM. COM file: is a command-line tool that allows you to set up execution without user interaction. To do this, you can use a command-line parameter, a configuration file, or a combination of these two methods.

(2) SQLIOSIM. EXE file: is a graphical interface application that can accept without command line arguments. However, SQLIOSim.exe does not load the preset configuration file.

(3) Sqliosim.cfg.ini file: This is the current environment Profile (config file), so adjust the parameters of the Sqliosim, this file will be used to hold the relevant settings, if deleted, the system will restore the default values. Without this file, the SQLIOSim is automatically generated after the first execution.

(4) Sqliosim.log.xml file: Store Sqliosim after the execution of the relevant records. The results of each execution are appended to this file.

(5) Errorlog.xslt file: Sqliosim.log.xml need to use this ERRORLOG.XSLT file for conversion.

x64-bit version of SQLIOSim tool:

Http://download.microsoft.com/download/6/5/2/65286f65-bff2-42b8-b0c9-87f117855069/sqliosimX64.exe

Step 1: execute the SQLIOSim.exe graphical interface application. You must have at least one data file and one log file. After setting the appropriate parameters, click Start.

Precautions:

File *.mdx: Equivalent to *.mdf, which is the data file.

File *.ldx: Equivalent to *.ldf, which is the log file.

650) this.width=650; "title=" clip_image002 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image002 "src=" http://s3.51cto.com/wyfs02/M02/53/AD/wKioL1Rtip-w8_mKAAFSu_sXE8g412.jpg "height=" 406 "border=" 0 "/>

650) this.width=650; "title=" clip_image004 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image004 "src=" http://s3.51cto.com/wyfs02/M00/53/AD/wKioL1RtiqCxjX4qAAFuIObxADw617.jpg "height=" 246 "border=" 0 "/>

Step 2: The output file Sqliosim.log.xml is in XML format, the downloadable tool SQLIOSim Parse, which reads the output XML format into an easy-to-read GUI format.

Tool Address: http://sqliosimparser.codeplex.com/releases/view/34854

650) this.width=650; "title=" clip_image006 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image006 "src=" http://s3.51cto.com/wyfs02/M01/53/AD/wKioL1RtiqPTVZhbAAF1M96ZNiE155.jpg "height=" 488 "border=" 0 "/>

650) this.width=650; "title=" clip_image008 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image008 "src=" http://s3.51cto.com/wyfs02/M02/53/AD/wKioL1RtiqShZkR6AACnuBFRohk471.jpg "height=" "border=" 0 "/>

Appendix: sqliosim.com command-line tool.

650) this.width=650; "title=" clip_image009 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image009 "src=" http://s3.51cto.com/wyfs02/M02/53/AF/wKiom1RtijCQZPKrAAEDpdMXOwo727.jpg "height=" 196 "border=" 0 "/>

Based on the parameters, the command parameters are configured and executed. Use IE to read results sqliosim.log.xml.

file:sqliosim.cfg.zip, contains 5 configuration files that can be used as input parameters.

(1) General testing recommended by Default.cfg.ini.

(2) Hwcache.cfg.ini hardware cache behavior test.

(3) Nothrottle.cfg.ini test system under high query pressure.

(4) Seqwrites.cfg.ini simulates basic import behavior such as bcp and restore.

(5) Sparse.cfg.ini tests sparse file behavior through DBCC and database snapshots.

This article is from the "Dripping Stone Wear" blog, please be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1580080

SQLIOSim simulating SQL Server behavior to test IO performance