In a 2007 survey of 182 database administrators, 54% use SAN (storage area network) for SQL. iSCSI SANs allow you to attach a few dozen individual hard drives to each logical unit number (LUN). As your system grows, additional hard drives can be added into the RAID group to improve performance capabilities.
One main benefit to using iSCSI to attach your SQL Server to a SAN is that it reduces SAN infrastructure set-up costs. There also are no additional fibre network costs to consider when configuring your solution, which means that there are no delicate fibre cables to handle.
In this eBook learn about gearing up for SANs on a SQL Server and how this solution can facilitate environment scalability.