2
Executive summary
Always a critical part of the IT infrastructure, databases are at the heart of a number of trends in IT:
Demand for large symmetric multiprocessing (SMP) type scalability in a Linux or Microsoft®
Windows® environment
Complex workloads that demand better response times and increased I/O operations per second
(IOPS)
Oracle applications and data are growing in size and complexity. Some applications running on
32-bit platforms may be reaching the limits of the architecture, specifically regarding the amount of
addressable memory.
Organizations are now able to migrate complex solutions from high-cost proprietary systems to
lower-cost Linux or Windows-based systems.
Organizations are consolidating applications to fewer servers to simplify critical data center
operations. Consolidation can reduce cost, management complexity, and physical space
requirements in the data center.
Historically, different computer system components have advanced at different relative rates.
Although disk capacity has improved somewhat, disk performance ranks at the bottom with no
significant improvement compared to million-fold boosts by other system components such as
servers.
Online transaction processing (OLTP) applications such as enterprise resource planning (ERP), supply
chain management (SCM), web-based e-commerce systems and even extract, transform and load
(ETL) applications can benefit from the performance of a scale-up architecture. More importantly, the
HP ProLiant DL980 G7 with HP VMA-series Memory Array solution offers the capacity to consolidate
and manage these applications in a single server. Any database application that requires increase in
performance including lower user response times, and higher throughput and IOPS is a candidate for
these configurations.
Systems such as large e-commerce websites that must respond to spikes in demand from large
numbers of users and a high volume of transactions should also see improvement. With these
applications, large amounts of memory are required to maintain connection context for every
database object opened by a user in addition to storage acceleration for significant I/O
performance.
This white paper describes three recommended configurations to support small, medium and large
OLTP solutions, capitalizing on the power of the HP ProLiant DL980 G7 server, HP VMA3210
Memory Array appliance, Linux, and Oracle 11gR2 database. The objective of these configurations
is to meet or exceed the demanding OLTP performance requirements, reduce the time to purchase and
implement the solution as well as to minimize any implementation risks.
The recommended configurations described in this paper include the storage configuration, Oracle
database setup, best practices, and a bill of materials.
The configuration information is based on data collected in HP’s solution performance lab and proof
of concept testing.
Target audience: This white paper is intended for system architects and decision makers who have
responsibility for evaluating, purchasing, recommending and/or implementing database applications
based on Oracle databases. Previous knowledge of Linux, Oracle database software, HP ProLiant
servers, and HP VMA-series Memory Array products would be advantageous but is not required.
This white paper describes testing performed in October 2010 and May 2011.
(22 Seiten)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern