Summary
Choosing a storage system for SQL Server 2005 data and log files is very important for overall I/O performance, storage flexibility, manageability, and scalability. We have discussed the different types of data transport interconnects that are available—SCSI, Ethernet, and FC—and the various data transfer protocol types—SCSI, iSCSI, FCP, and TCP/IP—and how they interact with the three main storage system configurations, DAS, NAS, and SAN. There are many factors to consider when choosing a storage system for SQL Server data. Although it is more expensive than DAS or NAS, SAN storage also provides the greatest features and benefits, so you may have to make a trade-off between cost, performance, and features. Identifying those trade-offs ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
