Storage arrays are available in a wide spectrum of capacities and capabilities, and sorting through the options can be confusing. These guidelines can help you narrow down the type of storage array you need to house your SQL Server databases.

Snapshot methodologies. Snapshots work about the same in all storage arrays.The idea is to freeze all the blocks of data in a database and the structure of the data being captured at a point in time. Vendors use one of two basic methodologies for...