I have the
fsutil output from a SQL server. How do I determine proper alignment?
I'm having trouble putting this into context. I have a decent understanding of disks, how can I understand the rest of the information here?
Server 2008 and R2 will automatically align partitions on 1MB. MS chose this number because it's quite uncommon at this time to have a stripe size that doesn't not work well with a 1MB offset (and nobody's missing the wasted 1MB these days)
For R0,1,1+0 this will be fine unless your stripe size is >1MB.
Allocation Unit should be an integer multiple of stripe size. (Allocation Unit and Cluster Size [in NTFS context only] are the same)
If you create multiple logical disks in the hardware raid adapter, watch that they are also aligned. Most controllers will do this automatically these days.
This should be what you are after: http://support.microsoft.com/kb/929491
To verify that an existing partition is aligned, divide the size of the stripe unit by the starting offset of the RAID disk group. Use the following syntax: ((Partition offset) * (Disk sector size)) / (Stripe unit size) Note Disk sector size and stripe unit size must be in bytes or in kilobytes (KB).
These examples shows that the partition is not aligned correctly for a 256-KB stripe unit size until the partition is created by using an offset of 512 sectors (512 bytes per sector).
More info on the link including wmic commands