SQL Server and SAN Technology

With to the increased use of storage area networks (SANs) in SQL Server environments, it is important to understand the design and performance implications of implementing SQL Server databases on SANs. SANs are becoming increasingly more common in SQL Server environments these days for a number of reasons:

• Increasing database sizes

• The increasing prevalence of clustered environments

• The performance advantages and storage efficiencies and flexibilities of SANs

• The increasing needs of recoverability and disaster recovery

• Simplified disk administration

In large enterprises, a SAN can be used to connect multiple servers to a centralized pool of disk storage. Compared to managing hundreds of servers, each ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.