The Windows Manager's Guide to iSCSI SANs - Chapter 2 - Gearing up for SANs on a SQL Server
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.
Senior Database Administrator and Architect,
Denny Cherry has more than a decade of experience managing SQL Server, including MySpace.com’s more than 175-million-user installation, one of the largest in the world. Denny’s areas of expertise include system architecture, performance tuning, replication and troubleshooting. He uses these skills in his role as a senior database administrator and architect at Awareness Technologies. Denny is a longtime member of PASS and Quest Software’s Association of SQL Server Experts and has written numerous technical articles on SQL Server management.
- Dell, Inc.
- 27 Aug 2008
- 20 Jun 2008