MSA Storage
1752772 Members
5013 Online
108789 Solutions
New Discussion

Re: 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

1 REPLY 1
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.