I've recently begun an exercise in looking into SQL best practices in terms of performance. I've read that it is recommended to put MS SQL data files (mdf) and log files (ldf) on separate volumes.
And this is how my organization has been doing it, when SQL was all on local server hard disks.
Now that the company has purchased an Equallogic SAN, I'm wondering if this still necessary. Dell support tells me that any volume created on the SAN will be spanned across all drives in the RAID set. In this case, that is 14 spindles. Dell says there is no performance advantage to separating those mdfs and ldfs since the volume will already have max I/O across all those drives. Creating two volumes isn't increasing the number of spindles in use...
Any thoughts or suggestions?