Re: Migrated database from local file system to SAN
- From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- To: Lu.Jiang@xxxxxxxxxxxx
- Date: Fri, 15 May 2009 21:48:28 +0200
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:
