O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required