what is storage alignment, what is the benefits of it.

I have a question from my coworker, he is the oracle DBA.

He asks me "Did the OS disk partition aligned in the VMs built for this purpose as well as in the template, RHEL5U8_ORAC11gRAC_temp?

Thanks,
"

what is the alignment ? what is the benefits of doing it.

Please advise, thank you.
Jason YuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bryant SchaperCommented:
as far as I am aware, this has not been an issue sense ESX 4.x.  You an check with your storage vendor.  Basically it is defining a starting block for the partition to increase performance.  In v5 it is 1MB for all filesystems created, but old upgraded vmfs partitions could be 64KB.  You would have to remove the partition and recreate it.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Performance of the VM disk I/O with the storage system.

Misaligned can cause degradation of VM db.

What is the storage system e.g. SAN

Check with SAN vendor NetApp have specific tools to use and fix.
Jason YuAuthor Commented:
We have netapp sans. Ef 550 and 8040 cluster. How can I make the storage aligned with os  ?
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

noxchoGlobal Support CoordinatorCommented:
You align the OS partitions to the storage. Not the storage to OS.
andyalderSaggar maker's framemakerCommented:
https://kb.netapp.com/support/index?page=content&id=1014111 is relevant to the 8040 which is classic NetApp.

As far as the all flash SANtricity EF550 is concerned it looks like it's impossible to misalign the storage as it uses 4K blocks natively.

www.vmware.com/pdf/esx3_partition_align.pdf has drawings to show what misalignment means - you could have to read 3 disk chunks to fetch a single data block , see the "Background" section of that document.

As already mentioned, recent versions of VMware, Windows and Linux automatically create an aligned filesystem so you don't have to worry about it any more.

Run fdisk -lu (or tell him to do it himself) to put his mind at rest.
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I would conduct your own tests in my experience DBA seem to get very excited about misaligned VMs and disks ....

I would test aligned versus unaligned in your environment for your database application and then see if you notice a difference.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jason YuAuthor Commented:
very good replies, thank you all, experts!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage

From novice to tech pro — start learning today.