Re: Flash technology based HDD will it make significant difference for OLTP applications?
Date: Mon, 7 Jan 2008 21:29:12 +0000
Things I don't like about it.
- It's end of life and the manufacturer is recommending other products from a different product line.
- I really don't like the idea of a san disk expiring after x I/O operations - I don't know how many i/os my disks have been subjected to, or are subjected to on a regular basis, and what the variation is. I've not yet met anyone who does either - though I have a sneaking suspicion that I might know at least one person who does keep this info.
then there's the broader question as to whether
- you are IO bound and
- the IO that is binding you is optimised.
Of course redo IO is optimised and often is a significant drain so SSD
devices might be approprate there.
On Jan 6, 2008 9:34 PM, Jurijs Velikanovs <j.velikanovs_at_gmail.com> wrote:
> Hello everyone and Happy new year to you,
> Just wonder if you can give your advice if the devices as following
> will make any difference in the context for Oracle RDBMS performance
> in the nearest time?
> From my point of view:
> - "Access time <0.02 ms" at least 30 times faster then today's HDD-s
> capable to achieve.It gives significant improvement for some profile
> Physical IO-s.
> - Current price 5k for 300GB might be acceptable for some systems even
> today. This parameter will go down within 1-2 years significantly.
> - Max read/write operation count is limited. In spite of that to use
> first point some organizations might choose to change HDD on regular
> basis (once a year/months) to improve throughput for some applications
> - It will not solve all problems but introduce significant
> improvements in some areas.
> PS I am sorry if this topic has been discussed already, please point
> me to the thread then.
> Thank you in advance,
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 07 2008 - 15:29:12 CST