||Oracle Tips by Burleson
As with everything else, the proof is in the
numbers. The following examines the actual results from multiple TPC-C
runs on the test systems using both RAID and SSD infrastructures.
The results showed clearly that in a CPU driven
system with the full database cached the performance of the system is
dependent on the number, speed, and capacity of the CPUs and the
latency and bandwidth of the interconnect. Look at the comparison
between the two setups (RAID and SSD) in a fully cached state in
This figure illustrates how the transactions per
second (TPS) are virtually identical with the same maximum TPS
inflection point for both the RAID and SSD system configurations. This
demonstrates that as the database becomes fully-cached the response of
the system is less dependent on the I/O subsystem and more dependent
upon the memory and CPU and in the case of real application clusters,
the speed of the interconnect.
Next will be an examination of the results for
each interface: RAID and SSD.
The above book excerpt is from:
Oracle RAC & Tuning with
Solid State Disk
Expert Secrets for High
Performance Clustered Grid Computing
Donald K. Burleson & Mike Ault