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

Having problems installing SQL 2008 Exp (3 Replies)

Request Help Please (0 Replies)

Cost Tracker in SSRS 08 (1 Reply)

UDFs GETWORDCOUNT, GETWORDNUM (24 Replies)

SSRS need help using inscope with a matrix (2 Replies)

only alphabat show (2 Replies)

show changes from and changes to in a history tabl (4 Replies)

Deleted Database (6 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 -