SAN or NAS for Oracle? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: SAN or NAS for Oracle?

  1. #11
    Join Date
    Nov 2001
    Posts
    335
    Of course you can perform you own test, however creating big datafiles is quite conclusive because every sungle block has to be "formatted" .
    Measure IO performance and u will see that you can pump much more data per sec on SAN versus same server using NAS.
    BTW, what is your evidence that NAS is same or better than SAN?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  2. #12
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Pffffffttttt.......... Solid State Drives all the way!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #13
    Join Date
    Jun 2006
    Posts
    259
    Solid State, well maybe...

    There are 3 options: Price, Performance and Availability.
    You may pick only 2.

  4. #14
    Join Date
    Jun 2006
    Posts
    259
    Quote Originally Posted by BV1963
    Of course you can perform you own test, however creating big datafiles is quite conclusive because every sungle block has to be "formatted" .
    Measure IO performance and u will see that you can pump much more data per sec on SAN versus same server using NAS.
    BTW, what is your evidence that NAS is same or better than SAN?
    That only tests Sequential Write performance. Which is hardly representative of a DB. Except for the online redo logs and maybe a few special cases.
    My thought would be to test Sequential Read, Sequential write, Random read and Random Writes. Then make a determination as to the best storage medium for your applicaiton.
    Last edited by ixion; 06-29-2006 at 12:02 AM.

  5. #15
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Just a thought:
    I really don't see an edge either by NAS or SAN storage device without considering or understanding first the other entities of an Infrastructure.
    I mean.. if your infra involved with low or high network performance. Or your servers maybe an entry-level, midrange, or high-end, this clearly will influence the performance of your storage device.
    If you have at least a midrange server which has a fibre channel bus architecture(IO comm channels/network/host adapters) then it will best fit to use SAN. Because SAN fits or maximized with this. On the otherhand NAS will be most likely be suitable in an infra where communication/network high performance become a standard(using Gigabyte Ethernet network systems/fibre optics).
    ---------------

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width