-
SAN or NAS for Oracle?
What is preferred for Oracle databases?
-
if one was better than the other, then the other wouldnt exist.
They are both good, depends what your nheeds are - do you understand the differences?
-
Thanks for the quick reply. To be honest, I dont know what the differences are. I would guess, at the very basic, my main interest would be how easy it is to take snapshots of prod db and restore it to test (on the same box or diff server). Can you tell me a good point to start looking at this? There is too much info on the web..
-
It's relatively easy, but SAN and NAS don't come into play either way. True, SAN and NAS have technology that let you break mirrors and get a snapshot of your data, but so do a lot of other storage devices.
Jeff Hunter
-
SAN storage attached to the server via switch and HBA .
NAS storage is mounted on the server via another server , almost like NFS.
Obviously for the system with the high perfromance requirements and expectation SAN is a must. Otherwise NAS will do.
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
and what evidence do you have that NAS is bad for performance?
-
your enterprise storage admin is the weakest link - trust no one Mulder . SANE SAN is must read
I'm stmontgo and I approve of this message
-
To the OP, just checking you realise this: Oracle only support certain NAS devices: http://www.oracle.com/technology/dep...ndors_nfs.html
-
I could do fancy testging to prove it, but here is the very simple one:
Try to create a large datafile (above 4Gb) on both systems keeping everything else the same and you will see the difference. It is not unusual to have 10-15Mb per seconde transfer rate on NAS and much high on SAN. If you can live with the slower IO go for NAS, it is cheaper. Otherwise stick with the SAN
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
creating a tablespace isnt a very good indicator of whether NAS or SAN is good enough for your app. It proves nothing
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|