Unsolved
This post is more than 5 years old
2 Intern
•
211 Posts
0
2457
July 1st, 2016 07:00
Oracle Performance differences: Place DB on VM disk, or on NFS?
We have two designs.
1. VM hosts access Oracle DB's on NFS@VNX (volumes) directly on the storage. VM and NFS volumes where DBs are located are on separated NFS volumes
2. VM hosts access Oracle DB's created on VM disk in the same NFS datastore/volume
Can anybody please share any pros and cons between these two designs? We seems experiencing performance issues with 2nd option, Any explanation on that?
Thank you!
No Events found!
Rainer_EMC
4 Operator
•
8.6K Posts
0
July 1st, 2016 14:00
Is the data store on the second option also via NFS from the VNX or via Fibre Channel ?
emcmagic
2 Intern
•
211 Posts
0
July 2nd, 2016 05:00
in both options, the data stores are in NFS based, not FC.
Thanks!
umichklewis
3 Apprentice
•
1.2K Posts
0
July 5th, 2016 05:00
The host-based IO patterns (random) are most-likely very different that the database access patterns (sequential). Imagine it like this: you have a steady stream of small-block random I/O created by the VMs themselves on their datastores. Then, you also have large-block random I/O to the databases themselves on the same disk. The array has two different access patterns to deal with, so performance is non-optimal. Best bet would be to separate them for performance.
emcmagic
2 Intern
•
211 Posts
0
July 6th, 2016 14:00
You mean to put VM host on one data store, and to put Oracle DB files in the other datastore? If yes, then how to allow VM host on one datasotre to access DB files on the other data store? this sounds like a VMware question, will you be able to explore this topic a little bit more
Thanks!
umichklewis
3 Apprentice
•
1.2K Posts
0
July 7th, 2016 06:00
You mentioned putting the NFS volumes separately from the VMs. I assumed you were creating the DBs on an NFS export, then mounting them to the VMs. I'm no VMware expert, but I assume this is possible in the management interface.