Planning the SQL Server Disk Layout
As you saw earlier in this chapter, you should configure your I/O system properly to avoid overloading it. Overloading the I/O subsystem causes the I/O latency to increase and degrade SQL Server performance. In this section, you will learn how to build a SQL Server system that can perform within the limitations of your subsystem. The first part of this configuration exercise shows you how to determine the I/O requirements of your system. Then you will plan and create your system.
Determine I/O Requirements
Determining the I/O requirements of a system that exists as only a concept can be difficult if not impossible. However, if you can’t determine the I/O requirements from hard data, you might be able to gather ...
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.
