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:

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:

IO Subsystems, Performance Tuning, Tools

Leave a Reply Cancel reply

Other articles

SQL101: Application data consistency checking

It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over

SQL101: Phishing attacks

I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link –

SQL101: Top Ten SQL Server Performance Tuning Best Practices

There are a huge number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially

The Curious Case of… no buffer pool memory and no OS memory available

Jonathan had a client issue recently where SQL Server’s buffer pool had been forced down to a ridiculously small size, only a few hundred MB,

The SQL Server Transaction Log, Part 3: The Circular Nature of the Log

(This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the

SQL101: Indexing Strategies for SQL Server Performance

One of the easiest ways to increase query performance in SQL Server is to make sure that it can quickly access the requested data, and

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.