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 2,695 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

Getting an error for this query (1 Reply)

Efficiently supplying xml data for treeview (3 Replies)

Update Statement (1 Reply)

Clean text files externally or internally (0 Replies)

Open more than 1 .sql file then execute it once (2 Replies)

UniqueIdentifier Self referencing foreign key (3 Replies)

SQL Server Management Console Express and Linked S (1 Reply)

help with dynamic sql within functions (8 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 -

SQL Server Jobs