RE: Migrated database from local file system to SAN
- From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
- To: "Mathias Magnusson" <mathias.magnusson@xxxxxxxxx>
- Date: Fri, 15 May 2009 16:36:41 -0400
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@xxxxxxxxx [mailto:mathiasmag@xxxxxxxxx] 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@xxxxxxxxxxxx> 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@xxxxxxxxx]
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@xxxxxxxxxxxx> 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
Other related posts:
