RE: Migrated database from local file system to SAN
Date: Fri, 15 May 2009 16:36:41 -0400
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890D85A677_at_edmtpmail01.ad.umassmed.edu>
Thanks for your help. I would do it on a test environment to see how much we can gain. That would also make us easy to take OS level snapshot to database files, add another way for disaster recovery. Will let you know how it goes.
I knew 1+0 would be faster for write/ read, but it had been set up that way before I got here.
Regards,
Lu
From: mathiasmag_at_gmail.com [mailto:mathiasmag_at_gmail.com] On Behalf Of Mathias Magnusson
Sent: Friday, May 15, 2009 3:48 PM
To: Jiang, Lu
Cc: Jared Still; oracle-l-freelists
Subject: Re: Migrated database from local file system to SAN
The answer then is that you will probably be able to make it significantly faster. If you can run on more spindles, fill just the outer parts on the disks and place the objects while using what cache the san and OS has, you ought to see good improvement. If you on the other hand were to exceed the max throughput of the controller )not the fiber, and you had higher before, then you could see a degradation (solvable by using more controllers (HBAs) ).
It depends, but the setup you seem to be getting ought to let you get the speed you need, only limited by the way you set it up.
If you need speed, why are you running Raid 5 on local disks? That is rarely improving speed over 1+0 when the disks matters for your performance.
Mathias
On Fri, May 15, 2009 at 9:28 PM, Jiang, Lu <Lu.Jiang_at_umassmed.edu> wrote:
Thanks all for your inputs. Our current local drives are in RAID 5. The disk speed of SAN is 15K fiber or could be higher. The connectivity to SAN is via dedicated 2 GB fiber with failover.
From: Jared Still [mailto:jkstill_at_gmail.com]
Sent: Friday, May 15, 2009 2:40 PM
To: Jiang, Lu
Cc: oracle-l-freelists
Subject: Re: Migrated database from local file system to SAN
On Fri, May 15, 2009 at 8:17 AM, Jiang, Lu <Lu.Jiang_at_umassmed.edu> wrote:
Hi DBAs,
Did anyone migrated database from local file system to SAN, is the performance much better?
As Mathias stated, it really depends on what you are going from and to.
If the db server has 5 IDE disks in a RAID 5, and you then move the storage to a high end SAN, and your connectivity is via 1Gb ethernet, it will probably be faster on the SAN.
You can't make a comparison without details.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 15 2009 - 15:36:41 CDT