Microsoft SQL Server I/O Basics Chapter 2: SQL Server 2004 SP4 and SQL Server 2005

Overview

Microsoft SQL Server 2005 continues to innovate and extend I/O performance and reliability. With new innovations come new terms, designs, and algorithms. The administrator of a SQL Server 2005 installation will find that visibility into the SQL Server I/O subsystem has been significantly increased. A primary focus of the SQL Server 2005 I/O design was overall stability of performance and data integrity as these relate to the outside influences of the I/O subsystem/path. The new and extended features provide both more visibility and more capabilities. One can maintain a SQL Server 2005 installation with high confidence in the system. This paper introduces new terms, discusses maintenance and configuration issues, new and improved error messages, and I/O enhancements.