Use SQLIOSIM to simulate SQL Server disk activity

By Bill Graziano on 8 March 2007 | 2 Comments | Tags: Disk Tuning


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. Follow the link to Use SQLIOSIM to simulate SQL Server disk activity...

Discuss this article: 2 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

SQL Server 2000 I/O Basics (16 January 2006)

Top Six FAQs on Windows 2000 Disk Performance (24 March 2003)

Other Recent Forum Posts

Traditional Approach Vs Property Bag Tables Advice (4 Replies)

Guidance with sql query (2 Replies)

General Structure (0 Replies)

Update Table from 2nd table with 2 column join (2 Replies)

Dynamic view (7 Replies)

SQL Server 2008 querying Active Directory (9 Replies)

Overlapping Date Ranges - Remove dup Permutations (6 Replies)

rows to columns (7 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -