2.4. Selecting an appropriate storage system

In addition to DAS, recent years have seen the introduction of a number of other types of storage solutions. As well as DAS, this section will investigate Fibre Channel and iSCSI SANs. We'll explore their advantages and disadvantages for use in SQL Server systems from various perspectives, including performance, cost, manageability, and disaster recovery.

2.4.1. Direct-attached storage

Of the three storage options presented in this section, DAS is the most established and is used in a large percentage of SQL Server systems of varying size and usage profiles. As the name suggests, DAS systems connect disks directly to a server, either internally within the server itself or in external storage cabinets ...

Get SQL Server 2008 Administration in Action 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.