Expand All
Automate Testing of Your Stored Procs
Streamline Your Database Setup Process with a Custom Installer
Stop SQL Injection Attacks Before They Stop You
Get a Lean, Mean Dev Machine with the Express Editions of Visual Basic and SQL Server 2005
Keep Bad Guys at Bay with the Advanced Security Features in SQL Server 2005
AMO Lets You Dig Deeper into Your Data from Your Own Applications
Make Sense of Your Web Feedback using SQL Server 2005
Fuzzy Lookups and Groupings Provide Powerful Data Cleansing Capabilities
Unearth the New Data Mining Features of Analysis Services 2005
Using XQuery, New Large DataTypes, and More
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

SQL Server I/O Basics, Chapter 2

Published: July 19, 2006


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


638 KB
Microsoft Word file
Get Office File Viewers

© 2016 Microsoft