SQL Server Database Engine Input/Output requirements
This article describes the SQL Server Database Engine Input/Output requirements.
Original product version: SQL Server
Original KB number: 967576
SQL Server requires that systems support guaranteed delivery to stable media, as outlined in the following download documents:
The above two documents also apply to SQL Server 2014. This requirement includes, but is not limited to, the following conditions:
Windows logo certification
No data rewrites
Systems that meet these requirements support SQL Server database storage. Systems do not have to be listed on the SQL Server storage solutions 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.
The incorrect use of SQL Server with an improperly tested solution may result in data loss, including total database loss.
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
Microsoft recommends use of Windows Logo certified products. To determine whether your solution supports "guaranteed delivery to stable media" as outlined under the 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.
It is a common troubleshooting practice for a Microsoft Support professional to ask you to disable nonessential jobs and to disable or remove third-party components, move database files, uninstall drivers, and perform similar actions. We always try to reduce the scope of the issue while we work to identify it. After an issue is identified as unrelated to the jobs or third-party products, those jobs or third-party products may be reintroduced to production.
For more information, see the following article:
The following table provides links to additional information that is related to specific I/O configurations.
|SQL Server I/O Internals|
|File System Features
|Physical layout and design
|NAS (Network Attached Storage)||Description of support for network database files in SQL Server|
|iSCSI||Support for SQL Server on iSCSI technology components|
|Mirroring and AlwaysOn availability groups||
|I/O affinity||INF: Understanding How to Set the SQL Server I/O Affinity Option|