Re: SSD Storage

From: Kellyn Pot'Vin <kellyn.potvin_at_ymail.com>
Date: Fri, 19 Oct 2012 17:54:52 -0600
Message-ID: <a0i06rj3ukg2km8vtege9xbm.1350690892407_at_email.android.com>

Sheesh, I should be paying better attention to topics...:) I've done numerous optimization projects with fusionIO for the SSD option, among others...

I can give you a few ideas where to start on "what" should move.

1. Inspect temp usage and see if high IO is an issue here that could benefit a move.
2. Look at objects, indexes and tables that have high IO, time spent on scans.
3. I think articles already give this solid advice but don't put redo logs on SSD.. You will not attain a performance gain.

Although any SSD will offer enhanced performance, there are so many other pieces of hardware between the database and the SSD option you choose that can throttle performance... Carefully look at choices on bus, firmware,etc... Also recognize the lifespan of some of this hardware and the cost to mirroring.

Create its own ASM diskgroup, yet and enjoy....=)

Kellyn Pot'Vin
Sr Technical Consultant
Enkitec

Martin Berger <martin.a.berger_at_gmail.com> wrote:

>Jeff,
>I fear no person on this list can answer your question.
>But you can try to figure out where most of the time is spent, check if
>SSDs helps there.
>If they do, put them there.
>At least check where SSDs will help best - you should be able to estimate
>the amount of time you will save with these SSDs.
>
>Martin
>
>
>On Fri, Oct 19, 2012 at 6:15 PM, Jeff Thomas <dbmangler_at_gmail.com> wrote:
>
>> What a timely topic.
>> The powers to be at our shop decided to purchase a separate server pool for
>> SSD disks to be allocated to a database earmarked for an EDW project.
>> Like the original article in this thread - I'm unsure as to what do with
>> it. For example, would it make sense to create a separate ASM disk group
>> consisting of just the SSD Luns and allocate the hot segments to this disk
>> group in this database?
>>
>> Best,
>> Jeff
>>
>>
>> On Thu, Oct 18, 2012 at 2:59 AM, Jonathan Lewis <
>> jonathan_at_jlcomp.demon.co.uk
>> > wrote:
>>
>> >
>> >
>> > I recently compiled a list of articles by Guy Harrison on SSD - largely
>> > related to Exadata, but they may prompt some thoughts.
>> > http://jonathanlewis.wordpress.com/2012/10/05/ssd-2/
>> >
>> > Regards
>> >
>> > Jonathan Lewis
>> > http://jonathanlewis.wordpress.com/all_postings
>> >
>> > Author: Oracle Core (Apress 2011)
>> > http://www.apress.com/9781430239543
>> >
>> > ----- Original Message -----
>> > From: "Cary Millsap" <cary.millsap_at_method-r.com>
>> > To: <howard.latham_at_gmail.com>
>> > Cc: "ORACLE-L" <oracle-l_at_freelists.org>
>> > Sent: Thursday, October 18, 2012 4:21 AM
>> > Subject: Re: SSD Storage
>> >
>> >
>> > |I invite you to have a look, too, at
>> > | http://carymillsap.blogspot.com/search?q=ssd
>> > | Cary Millsap
>> > | Method R Corporation
>>
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Oct 20 2012 - 01:54:52 CEST