SQL Server I/O Basics, Chapter 2

Summary

As the administrator of a SQL Server 2005 installation, you 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 related to the outside influences of the I/O subsystem/path. The new and extended features provide both more visibility and more capabilities.

This white paper introduces new terms, discusses maintenance and configuration issues, new and improved error messages, and I/O enhancements. After reading this document you will better understand SQL Server I/O needs and capabilities in SQL Server 2000 Service Pack 4 and SQL Server 2005.

Note: To help you understand the terms and concepts in this document, it will help to review SQL Server 2000 I/O Basics.

Included in This Document

  • Introduction

  • Terms

  • Maintenance and Configuration

  • Microsoft SQL Server 2005 I/O Error Message Changes and Additions

  • Microsoft SQL Server 2005 Enhancements

  • Conclusion

  • References

Download

DownloadSQLIOBasicsCh2.doc
638 KB
Microsoft Word file
Get Office File Viewers