请选择您需要帮助的产品

Microsoft SQL Server Database Engine Input/Output Requirements

Article ID: 967576 - View products that this article applies to.

Source: Microsoft Support

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Back to the top | Give Feedback

Introduction

SQL Server requires systems to support guaranteed delivery to stable media, as outlined in the following download document:

Microsoft SQL Server Always-On Storage Solution Review program

(http://download.microsoft.com/download/6/E/8/6E882A06-B71B-4642-9EB4-D1EA0D6223C8/SQL%20Server%20IO%20Reliability%20Program%20Requirements%20Document.docx)

This requirement includes, but is not limited to, the following:

Windows logo certification
Write ordering
Caching stability
No data rewrites

Systems that meet these requirements support SQL Server database storage. Systems do not have to be listed on the SQL Server Always-On site, but they must guarantee that the requirements are met.

SQL Server maintains the Atomicity, Consistency, Isolation and Durability (ACID) property by using the Write-Ahead Logging (WAL) protocol.

WAL references

SQL Server Books Online outlines the ACID Properties (Atomicity, Consistency, Isolation and Durability)
KB230785 SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability

SQL Server data can be stored on I/O systems that guarantee delivery to stable media as outlined under the Microsoft SQL Server Always-On program.

Warning:Incorrect use of SQL Server with an improperly solution may result in data loss, including total database loss.

Technical support

Microsoft will provide full support for SQL Server and SQL Server-based applications. However, issues that have, or caused by, the I/O solution will be referred to the device manufacturer. Symptoms may include, but are not limited to, the following:

Database corruption
Backup corruption
Unexpected data loss
Missing transactions
Unexpected I/O performance variances

If you use a solution that is not Windows logo certified, Microsoft cannot provide support for SQL Server or SQL Server-based applications. To determine whether your solution supports ‘guaranteed delivery to stable media’ as outlined under the Microsoft SQL Server Always-On program, check with your vendor. We also recommend that you contact your vendor to verify that you have correctly deployed and configured the solution for transactional database use.

For more information, Click the following article number to view the article in the Microsoft Knowledge Base:

913945

(http://support.microsoft.com/default.aspx?scid=kb;EN-US;913945)

Microsoft does not certify that third-party products will work with Microsoft SQL Server

841696

(http://support.microsoft.com/kb/841696/en-us)

Overview of the Microsoft third-party storage solutions support policy

Back to the top | Give Feedback

More Information

The following table provides links to additional information related to specific I/O configurations.

Collapse this tableExpand this table

SQL Server Books Online	NTFS Compression 231347 (http://support.microsoft.com/kb/231347/en-us) - SQL Server databases not supported on compressed volumes (except 2005 read only files) NTFS Encryption ACID Properties WAL Protocol Scalable Read Only Databases 910378 (http://support.microsoft.com/Default.aspx?kbid=910378) - Scalable shared database are supported by SQL Server 2005
SQL Server Always On Program	http://microsoft.com/sql/alwayson (http://microsoft.com/sql/alwayson)
SQL Server I/O Internals	http://technet.microsoft.com/en-us/library/cc966500.aspx (http://technet.microsoft.com/en-us/library/cc966500.aspx) http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx (http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx) 230785 (http://support.microsoft.com/kb/230785/en-us) - SQL Server 7.0, SQL Server 2000 and SQL Server 2005 logging and data storage algorithms extend data reliability 78363 (http://support.microsoft.com/kb/78363/en-us) - When Dirty Cache Pages are Flushed to Disk WebCast- Data Recovery in SQL Server 2005 (http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032290646&EventCategory=5&culture=en-US&CountryCode=US) MSDN article - Read-Only Filegroups (http://msdn2.microsoft.com/en-us/library/ms190257(SQL.90).aspx)
I/O Caching	234656 (http://support.microsoft.com/kb/234656/) - Using disk drive caching with SQL Server 86903 (http://support.microsoft.com/kb/86903/) - SQL Server and caching disk controllers 46091 (http://support.microsoft.com/kb/46091/) - Using hard disk controller caching with SQL Server 917043 (http://support.microsoft.com/default.aspx?scid=kb;en-us;917043&sd=rss&spid=2852) - Key factors to consider when evaluating third-party file cache systems with SQL Server
Physical Layout and Design	Physical Database Layout and Design (http://technet.microsoft.com/en-us/library/cc966414.aspx)
TEMPDB	917047 (http://support.microsoft.com/?kbid=917047) - Microsoft SQL Server I/O subsystem requirements for the tempdb database Working with tempdb in SQL Server 2005 http://technet.microsoft.com/en-us/library/cc966545.aspx (http://technet.microsoft.com/en-us/library/cc966545.aspx) Optimizing tempdb Performance http://msdn.microsoft.com/en-us/library/ms175527.aspx (http://msdn.microsoft.com/en-us/library/ms175527.aspx)
Utilities	Performance: SQLIO http://www.microsoft.com/downloads/details.aspx?familyid=9A8B005B-84E4-4F24-8D65-CB53442D9E19&displaylang=en (http://www.microsoft.com/downloads/details.aspx?familyid=9A8B005B-84E4-4F24-8D65-CB53442D9E19&displaylang=en)
Diagnostics	156932 (http://support.microsoft.com/default.aspx?scid=kb;en-us;156932) - Asynchronous Disk I/O Appears as Synchronous on Windows NT, Windows 2000, and Windows XP 826433 (http://support.microsoft.com/default.aspx?scid=KB;[LN];826433) - Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems 897284 (http://support.microsoft.com/kb/897284/en-us) - SQL Server 2000 SP4 diagnostics help detect stalled and stuck I/O operations (applies to SQL Server 2005) 828339 (http://support.microsoft.com/default.aspx?scid=KB;[LN];828339) - Error message 823 may indicate hardware problems or system problems in SQL Server 167711 (http://support.microsoft.com/kb/167711/en-us) - Understanding Bufwait and Writelog Timeout Messages
NAS (Network Attached Storage)	304261 (http://support.microsoft.com/kb/304261/en-us) - Description of support for network database files in SQL Server
iSCSI	833770 (http://support.microsoft.com/kb/833770/en-us) - Support for SQL Server 2000 on iSCSI technology components (applies to SQL Server 2005)
Mirroring	910716 (http://support.microsoft.com/kb/910716/) - Support for third-party Remote Mirroring solutions used with SQL Server 2000 and 2005 White paper - Database Mirroring in SQL Server 2005 (http://technet.microsoft.com/en-us/library/cc917680.aspx) White paper - Database Mirroring Best Practices and Performance Considerations (http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/DBM_Best_Pract.doc)
I/O Affinity	298402 (http://support.microsoft.com/kb/298402/en-us) - Understanding How to Set the SQL Server I/O Affinity Option

Back to the top | Give Feedback

DISCLAIMER

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.

Back to the top | Give Feedback