Support for SQL Server on iSCSI technology components

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Summary
Microsoft supports Microsoft SQL Server when it is deployed on Internet small computer system interface (iSCSI) technology components that have received the "Designed for Windows" Logo Program qualification. SQL Server installations that use iSCSI will require these iSCSI hardware devices in addition to the network adapters that are required for typical network communications.
More information
iSCSI is a SCSI transport protocol for mapping block-oriented storage data over TCP/IP networks. When you deploy SQL Server in an iSCSI environment, Microsoft recommends that you use appropriate caution. The involvement of a network may introduce components that are not typically viewed as high speed I/O paths.

Microsoft operating systems present the iSCSI devices as ordinary drives. To users and applications, including SQL Server, the remote destination is encapsulated. To maximize throughput, use caution to make sure that the computer that is running SQL Server is configured to maximize caching activities, and make sure that the latency that is involved with the iSCSI traffic is minimized. For more information about iSCSI technology and iSCSI support, visit the following Microsoft Web site:
SQL Server requires systems to support ‘ guaranteed delivery to stable media ’ as outlined under the SQL Server I/O Reliability Program Requirements. For more information about the input and output requirements for the SQL Server database engine, click the following article number to view the article in the Microsoft Knowledge Base:
967576 Microsoft SQL Server Database Engine Input/Output Requirements
Properties

Article ID: 833770 - Last Review: 05/11/2015 21:43:00 - Revision: 6.0

Microsoft SQL Server 2000 Developer Edition, Microsoft SQL Server 2000 Enterprise Edition, Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Express, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2008 R2 Analysis Services, Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Express, Microsoft SQL Server 2008 R2 Express with Advanced Services, Microsoft SQL Server 2008 R2 Standard, Microsoft SQL Server 2008 R2 Web, Microsoft SQL Server 2008 R2 Workgroup, Microsoft SQL Server 2012 Analysis Services, Microsoft SQL Server 2012 Business Intelligence, Microsoft SQL Server 2012 Developer, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Express, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2012 Web, SQL Server 2012 Enterprise Core, Microsoft SQL Server 2014 Developer, Microsoft SQL Server 2014 Enterprise, Microsoft SQL Server 2014 Enterprise Core, Microsoft SQL Server 2014 Express, Microsoft SQL Server 2014 Standard, Microsoft SQL Server 2014 Web

  • kbinfo KB833770
Feedback