Bitly URL: http://bit.ly/1QZpcUj

 

Tweet this document:

#Oracle Performance on the Vblock


Follow us on Twitter:

EMCOracle.jpeg.jpg

 

Visit the EMC store:

store_open-218x245.png

Click here to learn more about EMC’s Solutions for Oracle

Many customers are moving their Oracle databases to next generation platforms that provide private cloud capabilities including Database as a Service. If a customer needs to make such a move quickly, converged infrastructure systems are the best choice. But, there are challenges in deploying databases on these types of systems. Fortunately, Vblock can overcome many of the challenges that exist.


Challenges


Databases only perform as well as the systems they run on. Designing a system to power a true high performance database requires platforms that offer extreme performance and interoperability, as well as a strong knowledge of tuning parameters that help streamline the operation of the database.The engineering resources and expertise required to design such a system are not generally available to all organizations. This leads many organizations to turn to specialized consulting services to help them piece together a high performing database system using high‐end specialized components from various hardware vendors.


Solution: Vblock System 540


Vblock  540 is industry’s first all-flash based, converged infrastructure for high performance mixed workloads and is designed as a converged architecture for the most demanding transactional and response‐time‐sensitive databases that are needed by today’s businesses. Like all Vblock Systems, the 540 system is comprised of compute (database, application, and management servers from Cisco), network (three‐layer network and SAN technologies from Cisco), and storage (XtremIO à All Flash Array).

The high database performance in a Vblock 540 can be achieved by a combination of technologies as summarized in Figure 1.

 

aa11.png
Figure 1. VBLOCK SYSTEM 540 AT-A-GLANCE

 

A Vblock system 540 performed over 2, 00,000 IOPS with a 250 microseconds average response time for OLTP workloads. EMC internal lab has performed some testing in controlled environment and the results are shown in Table 1 and Table 2.

 

yy2.png

Table 1: Read IOPS and corresponding response times achieved along with sessions scale used in a Vblock system 540.

 

yy3.png

Table 2: Performance Statistics of a provisioned virtual environment


From the metrics shown in Table 1 and Table 2, we can see that physical and virtualized Oracle databases can work with acceptable performance degradation in a Vblock 540 environment.


To summarize, the VBlock540 is designed with the highest performing and most reliable components from Cisco, VMware, and EMC. Fast servers, switches, and storage (XtremIO) are utilized to ensure the highest throughput and lowest query response times possible. This extreme high performance coupled with the flexibility, availability, compression and in-line deduplication and scalability of the VBlock 540 delivers tremendous value for today’s most demanding high performance databases.