Re: Flash technology based HDD will it make significant difference for OLTP applications?
- From: Dan Norris <dannorris@xxxxxxxxxxxxx>
- To: j.velikanovs@xxxxxxxxx, oracle-l <Oracle-L@xxxxxxxxxxxxx>
- Date: Sun, 6 Jan 2008 14:10:55 -0800 (PST)
Hi Jurijs,
I don't have any direct experiences to share, but I can say that I have talked
to a lot of customers about memory-based storage in the past. The biggest
problem I've seen when memory-based storage is considered is that the
"solution" is considered before determining what the problem is. That is, if
you have a CPU bottleneck, then making the storage faster is not likely to make
a positive impact (in fact, possibly a negative impact).
If storage latency is your primary issue, then making the disk service time
shorter will likely make a big difference. I'm also interested in hearing
real-world experiences as I've only talked about this--not implemented it. In
most of the cases that I've encountered, I ended up talking the customer out of
making a memory-based storage purchase because it wouldn't have addressed the
issue that they were trying to solve at the time. I always add the caveat that
tuning is an iterative process, so it is likely that eventually storage will
become the bottleneck and it may be worth considering such a purchase at that
time.
Dan
----- Original Message ----
From: Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>
To: oracle-l <Oracle-L@xxxxxxxxxxxxx>
Sent: Sunday, January 6, 2008 3:34:41 PM
Subject: Flash technology based HDD will it make significant difference for
OLTP applications?
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?
http://www.sandisk.com/OEM/ProductCatalog(1331)-SSD_Ultra320_Wide_SCSI_35.aspx
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,
Jurijs
--
//www.freelists.org/webpage/oracle-l
Other related posts:
