In previous post “IO Subsystem load testing”, I test several tools for testing the IO Subsystem. However, those tools are either testing the IO through the sequence/random and perform them through various block size. They are not design specific for simulate the SQL IO operation.
SQLIOSlim is the tool from MSFT for perform the IO testing for simulate how SQL Server interact with IO subsystem. SQLIOSim is NOT the performance tuning tool. It is the tool let us know how the SQL Server interact with the IO Subsystem without having the SQL Server install.
You can download the SQLIOSim from here.
Start the SQLIOSim from sqliosim.exe
Configure the database file. mdx file is for the database file ( Mdf). ifx file is for the log file ( ldf), you can change the size from the screen. DO NOT use the same name/path with your existing SQL Server data file. The SQLIOSim would perform the SQL Server like IO operation on those files. If you use the existing file, it would cause your database corruption.
Click Start 
After it complete, it would generate the sqliosim.xml and errorlog.xslt. We can use IE to open the file
Use sqliosimparser to parse the output
The parser can be download from here.
SQLIOSim command line
SQLIOSim has the command line mode. We have to provide the configure file in order for it to run. The configure file can be created by using GUI or sqliosim.cfg.zip has some example for the configure file.
Reference
- Understanding SQLIOSim Output: http://www.sqlmag.com/article/sql-server/understanding-sqliosim-output
- SQLIOSim Parser by Jens Suessmeyer & Yours Truly: http://blogs.msdn.com/b/jimmymay/archive/2009/09/27/sqliosim-parser-by-jens-suessmeyer-yours-truly.aspx
Very Nice Blog Updation Keep Updating !!
ReplyDeleteWhere can I get sqliosimparser.exe console or win app? What is on code plex seems to be missing some reference files ..
ReplyDeleteMontblanc Meisterstück Geometric Solitaire Platinum Ballpoint Pen is the ideal writing tool for you to impress. This replica mont blanc fountain pen medium has proven to be replica montblanc heritage collection very popular among collectors because it is larger than a standard Classique ballpoint pen, but smaller than a large LeGrand pen, so it can be easily held in your hand. Each writing instrument in the series has more than 2,000 geometric facets, giving them a unique optical illusion that makes your eyes charming and fun. The geometry of Taipan Solitaire was born from the desire to combine Montblanc classic design with unique materials.
ReplyDeleteExcellent blog!!! I got to know more useful information by reading your blog. Thanks for posting this blog.
ReplyDeleteBig Data Training Institute in Pune
Hadoop Training in Pune