I'm trying to follow the advice from this TechNet article about partition alignment. Our San is an EMC, the disks are in a 4 disk raid 10. This services an I/O intensive application, 60:40 write:read.

According to the wmic query in the article for Partition_Offset, I get 1048576.

According to my SAN administrator the Stripe_Unit_Size is 524288000. Does that even sound right?

The simple calculation to find if you're aligned or not is:

Partition_Offset ÷ Stripe_Unit_Size 1048576 / 524288000 = .002

This is not an integer, so it appears we are not aligned.

Using diskpart to reformat the drives, what Partition_Offset and File_Allocation_Unit should we use?

migrated from dba.stackexchange.com Apr 20 '15 at 17:30

This question came from our site for database professionals who wish to improve their database skills and learn from others in the community.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy