April 27, 2010
A high-speed database solution has been developed as a result of a joint verification by Fujitsu and Oracle Corporation Japan.
With the systemization in recent years of many of business operations, data growth has become large and continuous. The result has been an increase in system performance issues. Similarly, service degradation is being felt in on-line transaction processing (OLTP) systems, due to limited database server capacity.
To avoid such OLTP performance degradation, data can be allocated in more dispersed patterns. But that means many additional HDDs, high levels of expertise, and large additional costs.
In this verification, Fujitsu's ETERNUS disk storage systems using Solid State Drives (SSDs), SPARC Enterprise UNIX servers for the process operations and performance testing, and the high-speed technology "Database Smart Flash Cache" available with Oracle Database 11g Release 2, were used in combination.
The results showed an up to 2.4 times improvement in OLTP performance compared with using traditional HDDs. This highlights the effective use of SSD in ETERNUS disk storage systems as large-capacity database cache. It also shows the ability to improve performance and more easily achieve system cost optimization.
*Note: Please refer to the following whitepaper for details of the verification result.
Verified system overview diagram
Using two Fujitsu SPARC Enterprise M3000 units, a 2-node Oracle Real Application Clusters was configured using Oracle Database 11g Release 2 Enterprise Edition
|MODEL||Fujitsu SPARC Enterprise M3000|
|CPU||SPARC 64 VII 2.75GHz (4 cores, 8 threads)|
|OS||Solaris 10 Operating System (Generic_141444-09)|
|DATABASE||Oracle Database 11g Release 2 Enterprise Edition
Oracle Real Application Clusters
Two ETERNUS DX80 units, one with SSDs and the other with HDDs, were used.
ETERNUS DX80 with SSDs
|MODEL||Fujitsu ETERNUS DX80|
|DISK DRIVE||SSD: 100 GB x 8
HDD: 300 GB (15,000 rpm) SAS disk drive x 2
ETERNUS DX80 with HDDs
|MODEL||Fujitsu ETERNUS DX80|
|DISK DRIVE||HDD: 300 GB (15,000 rpm) SAS disk drive x 24
(Extended drive enclosure x 1)
For clients, two BX620 S5 blades in the Fujitsu PRIMERGY BX600 Blade Server series
were used to run business applications.
|MODEL||Fujitsu PRIMERGY BX620 S5|
|CPU||Intel Xeon processor X5570 2.93GHz (4 cores) x 2|
|OS||Red Hat Enterprise Linux Server Release 5.3 (Tikanga)|
Storage management client
Storage management software was run on a further PRIMERGY RX300 server.
|MODEL||Fujitsu PRIMERGY RX300 S3|
|CPU||Intel Xeon 5160 processor 3.00GHz (2 cores)|
|OS||Microsoft Windows Server 2003 R2|
|STORAGE MANAGEMENT||ETERNUS SF Storage Cruiser 14.1
ETERNUS SF AdvancedCopy Manager 14.1
This verification was the first to be performed at the “SPARC Enterprise - Oracle Database Solution Development Center”. A new virtual facility, it utilizes capabilities at both Fujitsu's Platform Solution Center and Oracle's GRID Center to support detailed validation testing of combined SPARC Enterprise and Oracle solutions. This innovative facility was co-established by Fujitsu and Oracle Corporation Japan and opened in March 2010.
Product names mentioned in this article are trademarks or registered trademarks of their respective companies.