 |
|
Oracle Tips by Burleson |
SSD Average Transaction Time
Perhaps the most dramatic difference is in the average transaction
time results when comparing the RAID to the SSD system. As expected
from a review of the previous SSD results, a decrease in the average
transaction time should be expected allowing more transactions and
more bytes per second. However, a very dramatic decrease as cache
memory was reduced was seen.
Once dependence on the interconnect is mitigated, the transaction
times dramatically improved by several orders of magnitude. The
scale on the graph in Figure 4.10 is logarithmic. This means that
for one increase in scale on the vertical axis, an increase by a
factor of 10 can be seen. Compare the average transaction times in
Figure 4.10 to those from the RAID tests in Figure 4.6. The dramatic
difference between the two technologies can be seen as memory is
reduced. This indicates that by utilizing the RamSan400 SSD system
transaction times were improved by nearly a factor of 100, two
orders of magnitude!
The above book excerpt is from:
Oracle RAC
& Grid Tuning with Solid State Disk
Expert Secrets for High Performance Clustered Grid Computing
ISBN:
0-9761573-5-7
Mike Ault, Donald K. Burleson
http://www.rampant-books.com/book_2005_2_rac_ssd_tuning.htm |
