SQLIOSim is "NOT" an I/O Performance Tuning Tool What do I need to know about SQL Server database engine I/O? Should I run SQLIOSim? - An e-mail follow-up from SQL PASS 2008 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem If SQLIOSim encounters an error that would lead to possible data integrity issues details are logged and the testing is halted. The log file contains various details about each test pass executed. We recommend at least 10 test cycles at 300 seconds per cycle using the for a basic test. You typically have to run the utility with elevated administrator privileges. Using files that are smaller than the hardware cache does not exercise the I/O path fully. Update or add files that exercise the same I/O path as the SQL Server database files.īe sure to increase the size of the files so that any hardware cache performs physical I/O during the tests. It does not understand the SQL Server I/O format and would damage a database file in an unrecoverable fashion.įor most systems, including those with suspected I/O problems such as checksum failures, edit the SQLIOSim generates random data using the Crypro random data generators. Never use the same file names as a SQL Server database file. Multiple executions append to the log file. Created in the specified output directory. Tests sparse file behaviors that are used by DBCC and snapshot databases. Used to simulate load based activities such as BCP and restore. Tests pushing the system and drivers at high queue levels. Good for testing behaviors of the hardware cache. There are builds available for x86, 圆4 and ia64 platforms. ) and is also installed with the SQL Server 2008 components in the MSSQL\BINN location. SQLIOSim can be downloaded from the web ( We recommend you execute SQLIOSim on all I/O paths before you install the actual SQL Server components or anytime you encounter data integrity issues.
As an example, some of the testing phases perform unbounded I/O as we have encountered some drivers that will cause blue screens when the I/O depth becomes aggressive. SQLIOSim is NOT designed to be a performance testing utility as it combines known I/O patterns with random patterns in an effort to test the data integrity capabilities of your I/O path.
0 kommentar(er)
