Sun Microsystems and Oracle Team Up to Deliver Record Performance on One
Of the World's Largest Oracle Data Warehouse Configurations
Sun's Server and Storage Systems Achieve Record Performance on Massive 33 TB
Oracle Database
PALO ALTO, Calif., Nov. 15 /PRNewswire/ -- Sun Microsystems, Inc.
(Nasdaq: SUNW) today announced that the Sun Enterprise(TM) 10000 (also known
as Starfire(TM)) server and Sun StorEdge(TM) A5100 and A5200 fibre channel
disk arrays combined with Oracle8i and VERITAS Volume Manager 3.0.2 have
achieved record performance on one of the world's largest data warehouse
configurations, a massive 33 terabyte (TB) Oracle database. The Sun test
configuration performed at a record speed of 251,000 I/Os per second (IOPS) in
an I/O-intensive online transaction processing (OLTP) environment and achieved
throughput of 3 gigabytes (GB) per second.
"This performance achievement clearly demonstrates why Sun is an ideal
platform for large scale computing environments," said Raj Das, director of
product marketing for Sun Network Storage. "We provide end-to-end solutions
that integrate the operating system, compute engines, storage systems and
applications software to achieve the record performance, scalability and
reliability that are essential for demanding data center requirements."
The record-setting test results demonstrated how Sun Enterprise
10000 servers, Sun StorEdge A5100/A5200 disk arrays, and the Solaris(TM)
Operating Environment excel in very large database (VLDB) decision support and
data warehouse environments used for e-commerce, Web-based transactions, and
commercial applications. The modular nature of the Sun Enterprise 10000 server
and Sun StorEdge arrays enables the systems to scale capacity and performance
in a linear fashion. As a result, customers are able to create large-scale
systems that are ideally matched to the performance requirements of their
specific applications.
"We are extremely pleased with the performance of Oracle8i and of its
performance on Sun," said Barbara Reed, vice president, Sun Products Division,
Oracle Corporation. "These results show Oracle and Sun's ongoing commitment to
a high-performance, scalable, and reliable data warehouse solution."
Sun and Oracle Deliver Record Performance and Throughput Summary test
results showed that the Sun Enterprise 10000 server and Sun StorEdge
A5100/A5200 arrays combined with Oracle8i and VERITAS Volume Manager 3.0.2
configuration:
-- Produced record I/O performance with 251,000 IOPS, which is consistent
with the 3,000 mainframe MIPS rating of the Sun Enterprise 10000;
-- Delivered record I/O throughput of 3 GB/sec;
-- Simulated real world application environments including complex
high-performance data warehouse environments used for e-commerce,
Web-based transactions, and commercial applications;
-- Demonstrated the uncompromising reliability essential to
mission-critical data center applications using RAID 1+0 for data
protection;
-- Demonstrated ease of manageability and serviceability on a large scale
using VERITAS Volume Manager 3.0.2 to manage 2,880 disk drives;
-- Used Oracle8i to scan a 15 TB table in less than 2.5 hours. Oracle8i
also enabled the 15 TB table to be joined with a 1 TB table in less
than three hours.
"With data storage requirements doubling every 18 months, it is important
for companies to test large scale configurations to ensure that the
performance and capacity of the systems they are developing today will address
massive database requirements as they begin to emerge," said Roger Cox, chief
analyst for Dataquest. "Companies who are stepping up to this challenge today
will be ahead of the curve."
How Much is 33 TB?
To put this performance breakthrough in perspective, consider that 33 TB
is three times larger than the printed collection of the U.S. Library of
Congress. At the 3 GB per second I/O throughput demonstrated in this
performance test, a single Sun Enterprise 10000 server could read the Library
of Congress in just one hour.
Sun Microsystems and Oracle Show Commitment to Solving Data Warehousing
Needs
By creating one of the world's largest database test configurations, Sun
and Oracle have demonstrated a commitment to providing end-to-end enterprise
class solutions for the data warehousing market.
"Until now, the data warehousing/decision support market has not had the
focus it needs from systems vendors to meet its exploding requirements," said
Das. "It is rare that vendors invest the time and effort to explore whether
the massive configurations that the market are approaching are feasible in
terms of performance, reliability and manageability. Sun and Oracle have
stepped up to the plate by being among the first to demonstrate the ability to
support massive real-world configurations."
The TEST Sun's Strategic Applications Engineering Group (SAE) and Oracle's
DSS Group conducted three tests at Sun's Enterprise Test Center in Palo Alto,
California. The tests measured performance on the Sun Enterprise 10000 server
attached to Sun StorEdge A5100 and A5200 fibre channel arrays with VERITAS
Volume Manager 3.0.2 running Oracle8i in a 33 TB mirrored configuration.
The first test was designed to determine maximum I/O throughput of random
reads. One-kilobyte (Kbyte) random reads were issued across the entire disk
configuration. The configuration delivered record I/O performance at the rate
of 251,000 I/Os per second.
The second test measured IOPS on 1-Kbyte I/Os consisting of 50% reads and
50% writes, an I/O pattern which is typical of OLTP workloads. The
configuration delivered 202,600 IOPS.
The third test demonstrated the ability of the Sun Enterprise 10000 server
and Sun StorEdge A5100/A5200 arrays with Oracle8i and VERITAS Volume Manager
to manage huge, multi-terabyte tables and to execute a variety of queries
important to data warehousing workloads with record performance. The test
configuration performed I/O-bound queries, achieving a sustained I/O rate of
2 GB per second.
"With these imposing test results, Sun has visibly established their
leadership in providing a superior platform for real-world application
environments," said Fred van den Bosch, executive vice president of
engineering for VERITAS Software. "Running Oracle8i and VERITAS Volume Manager
on Sun's platform is proving to be a premier solution for e-business and
e-commerce customers, providing exceptional performance while increasing
application reliability and availability."
About Sun Network Storage
Sun Network Storage was formed by Sun Microsystems in July 1998, and is a
recognized multi-billion dollar industry leader in the UNIX(R) and open
systems storage market. Sun is changing the rules in network storage by
delivering software and hardware written to an open network architecture.
Sun's commitment to standards enables timely availability of new technology,
investment protection for existing technology, and a thriving partner
community. The comprehensive Sun StorEdge family of products enables customers
to match storage to the application while providing scalable capacity and
performance in a "pay-as-you-grow" architecture. |
