HPE EVA Storage
1752570 Members
5175 Online
108788 Solutions
New Discussion

Re: EVA4100 and SQL allocation unit size when formatting drive.

 
SOLVED
Go to solution
TTr
Honored Contributor

Re: EVA4100 and SQL allocation unit size when formatting drive.

The microsoft web site has many interesting articles. Search for "sql server storage alignment"

http://search.microsoft.com/results.aspx?mkt=en-US&setlang=en-US&q=sql+server+storage+alignment
Digex
Regular Advisor

Re: EVA4100 and SQL allocation unit size when formatting drive.

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx

Per that article it agree's with all of your statements.

Quote" 64-KB offset (128 sectors) is a common value that works on many storage arrays and has been used with success in the SQL Server test labs (at the time of writing this paper). Vistaâ ¢ and Windows Longhorn Server remove the need to manually establish correct alignment and use 1024 KB (2048 sectors) as a starting offset, which will probably work well for almost any array."

I wonder why HP EVA rep's say not do this at all.