In this session I will introduce the wide variety of options available for SQL storage and how to decide on a strategy. I will give some guidance on gathering your requirements, setting performance criteria for your intended solution and ways to level the playing field for vendors to propose solutions. We will look at identifying your usage patterns and deciding on what aspects of storage are most important to you, be it IO, bandwidth or capacity. We will look at the relationship between IO and bandwidth and how IO size can affect sizing. I will briefly go over why partition alignment is important. We will look at how your options are narrowed based on your HA / DR strategies (including changes coming with AlwaysON), as well as what non-SQL DR strategies are possible when using SAN storage. A brief overview of the difference between running FC and ISCSI SAN’s and the contrast between framed and frameless SAN’s. I will briefly cover when SSD’s and cloud storage should be considered as well as the benefits that are possible with PCI SSD’s, and then wrap up with ways to validate and test the solutions before you buy. 
Presented by Brett Roux at SQLBits IX
Slide Deck 818 KB