Re: Tip from mr. D.K. Burleson

On 27 Sept., 16:26, Helma <helma.vi..._at_hotmail.com> wrote:
> On Sep 27, 3:12 pm, Gints Plivna <gints.pli..._at_gmail.com> wrote:
>
>
>
>
>
> > On 27 Sept., 11:47, Helma <helma.vi..._at_hotmail.com> wrote:
>
> > > Hello fellow DBA's,
>
> > > I've read a article from Burleson where he's an enthusiast about solid
> > > state disks:
>
> > > " It's important for all Oracle professionals to learn about solid-
> > > state disk to understand how I/O bottlenecks will soon become a thing
> > > of the past. "
>
> > > and
>
> > > "The ancient platter-based disks from the 1960's will soon join paper
> > > tape and punched cards in the annals of IT history. "
>
> > > " In my reproducible benchmarks of SSD vs. platter disks, the response
> > > time benefits of using SSD with Oracle are amazing with blistering
> > > speeds that result in up to a 300x speed improvement. "
>
> > > ( full read athttp://www.dba-oracle.com/t_flash_disk_drives_ssd_ram_san.htm
> > > )
>
> > > He doesn't mention any drawback to this SSD. Does anyone here has
> > > experience with this SSD , and is it as big as mr Burleson says?
>
> > > TIA,
> > > Helma
>
> > Seehttp://www.freelists.org/archives/oracle-l/09-2005/threads.html#01024
> > check thread Solid State Disks for Databases
> > And especially look at answer by Cary Millsap.
>
> > Gints Plivnahttp://www.gplivna.eu
>
> Sveiks Gints!
>
> Thanks for your reply. It seems that most of the remarks are about
> price ( and the postings are 2 years old) and of course the Amdahl's
> law - but can we sweep this one under the ceteris paribus carpet?
> It seems a price/performance issue to me - a ratio that varies over
> time. What's the latest on this? Or am i missing something else?
>
> Regards,
> Helma- Pasl pt cit to tekstu -
>
> - R d t cit to tekstu -

Sveiki! :)

Sometimes postings won't get old (ok better out of date) quite a long time. Also this one - with SSD you can probably resolve some I/O problems but nothing more.
I've never used SSD so cannot say anything about them but I've seen quite many apps where throwing hardware in never would get any significant advantage because of serialization points, crazy sqls, crazy requirements and so on.
Yea I assume that there are cases when SSDs could help, but I think it is worth to consider them only for special purposes and after you have architected/optimized your app so that it scales well. Without scaling I don't think that any SSDs will help.

Gints Plivna
http://www.gplivna.eu Received on Thu Sep 27 2007 - 15:31:16 CDT