Use SQLIOSIM to simulate SQL Server disk activity

By Bill Graziano on 08 March 2007 | 0 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: 0 Comments so far. Print this Article. This page has been read 6,459 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email ThisSubscribe to this feedKick itSave to del.icio.usView blog reactions

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

Trigger including query data (1 Reply)

Unable to fail instance to 2nd node in cluster. (2 Replies)

Active Active 2k8 - Instance name (0 Replies)

unique/distinct values based on 4 of 5 columns (1 Reply)

How should I store lists of my users? (6 Replies)

Where IN this and IN that (2 Replies)

BCP to SP Returns Conversion Error (3 Replies)

grouping and counting a column (2 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

- Sponsor's Message -