RE: Migrated database from local file system to SAN

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: