Benchmarking the I/O Subsystem

The I/O subsystem is one of the most important components of your system, and one that can cause significant performance problems if it is not configured and sized properly. Any I/O subsystem is made up of finite components that have finite performance characteristics. Unfortunately, the DBA is not usually the person responsible for the I/O subsystem and must sometimes must prove that this component is a problem before any changes can be made. In this section you will learn how to gather that evidence.

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.