SQLTeam.com Logo

Return to Use SQLIOSIM to simulate SQL Server disk activity

Use SQLIOSIM to simulate SQL Server disk activity

Written by Bill Graziano on 08 March 2007

I regularly use SQLIO.EXE to gauge the maximum throughput a disk subsystem can sustain. Recently Microsoft released SQLIOSIM.EXE to provide better results for this type of test. However they didn't release any documentation on the tool and I could never figure out what it was trying to tell me. It looks like they finally did release a Knowledge Base article on SQLIOSIM. Give it a spin. I'd be curious to hear what you think of the tool.