SQL Server I/O Basics Chapter #2
Published Feb 21 2022 09:45 AM 1,506 Views
Microsoft
Move from: bobsql.com

Introduction

Microsoft® SQL Server™ 2005 continues to innovate and extend I/O performance and reliability. With new innovations come new terms, designs, and algorithms.

 

The SQL Server 2000 I/O Basics document is a prerequisite to the information contained in this document. Read it before you read this paper.

 

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 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. You can maintain a SQL Server 2005 installation with high confidence in the system.

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.

 

Download full article



 

Co-Authors
Version history
Last update:
‎Feb 21 2022 09:45 AM
Updated by: