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

Extracting data (2 Replies)

SQL query for grouping and join (3 Replies)

Select good hardware (3 Replies)

Advice on where to find info about designing Cubes (1 Reply)

Two Subqueries and a Calculated Field (2 Replies)

Pattern Identity (1 Reply)

update statistics taking too long (9 Replies)

Simple nested question (2 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 -