We are getting new Flash storage in to help alleviate SQL IO latency and performance issues. I'm wondering if there is a special configuration of these disks into an aggregate that will make performance the best it can be for these SQL workloads. Do I just make an aggregate the way i always used too with normal spinning disks or is there some configuration I'd benefit going with that i don't know about.
The best way to configure your workloads is to talk to your account team. Depending on the model, SQL can be fairly bandwidth intensive, so you may consider multiple volumes and LUNs to spread work across multiple affinities and SCSI threads (in terms of SAN). The account team can also pull in SQL architects who know how to set this up to best perform and run good.