sqlskills-logo-2015-white.png

Whitepaper on Predeployment I/O Best Practices, plus a few urban legends around SQL Server IO


There’s a new whitepaper on TechNet that I’ve just come across (even though it was published 6 months ago!) called Predeployment I/O Best Practices. It’s really good – discussing the following:



  • Guidelines for determining I/O capacity
  • Disk configuration best practices and common pitfalls
  • Using SQLIO to determine capacity and interpreting its results
  • Using System Monitor to monitor an IO subsystem

You can read it here and I’ve added a link to our whitepapers page.


While I’m on the subject of I/O, Bob Dorr (A Senior Escalation Engineer in PSS) published a blog post last year that debunks a couple of urban legends around SQL Server’s IO, specifically:

Check It Out!

SQLskills Complete Short Course Bundle

SQLskills Complete Short Course Bundle

Original price was: $4,575.00.Current price is: $899.00.

View Course


  • The myth that SQL Server used one thread per data file
  • The myth that a disk queue length greater than 2 indicates an I/O bottleneck

Check out his blog post and the subsequent discussion here.

Posted Under:

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

AI Stories and Thoughts

iAI is obviously the hot new thing and prognostications for the future range from the unicorns-and-rainbows life of idleness for us all to the post-apocalyptic

Explore

Reflections on 15 Years

(This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to

Explore

Summer Sale: $699 Blackbelt Bundle!

Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: Check It Out! SQLskills Complete Short Course Bundle $4,575.00 Original

Explore

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.

Collaborate With Us
Choose a Course