MSA Storage

SQL Server and MSA 2012fc

Mike Lawell
New Member

SQL Server and MSA 2012fc

I'm trying to find a good white paper or details on configuring the disks for SQL Server data files. Specifically in reference to the recommended allocation block size.



P.S. This thread has been moved from Disk Array to Storage Area Networks (SAN) (Small and Medium Business). - Hp forum moderator

Joshua Small_2
Valued Contributor

Re: SQL Server and MSA 2012fc

I haven't seen anything specific to this hardware.
The usual advice is down to separating disk groups between log files and data files.

Really, how busy is your environment expected to be? We've got an MSA2012fc with four separate SQL servers, two of which are pretty heavily utilised. The IO statistics barely rate a mention next to what the unit is capable of, and we didn't have the luxury of following those sorts of best practices for various reasons.