The Ready Bundle for Oracle is a solution designed to boost performance and operational agility for your database ecosystem. Oracle databases run the most complex and critical applications used by a company, often supporting ERP and CRM systems responsible for all back office processes. The pressure to modernize the database infrastructure means businesses are looking for solutions that offer greater agility, operational efficiencies, and resiliency in a single solution.
The Ready Bundle for Oracle integrates Dell EMC PowerEdge R940 servers, networking, and the enterprise VMAX 250F all-flash array into a Ready Solution. There is little, if any, of the risk associated with the best-of-breed approach that involves design, test, and release phases that accumulatively can take months or weeks to complete. All the engineering is included in the Ready Bundle, providing the business with a faster time-to-value in reaching operational readiness.
There is less risk too, as the entire solution is supported by a single vendor, full service company. Most anyone in the IT Organization understands the complexity of coordinating multiple vendors to resolve an issue impacting operations. Dell EMC solves this support challenge with three years of award-winning ProSupport services and a three-year extended hardware warranty. Application owners and DBAs call one number for server, networking, and storage support with the Ready Bundle for Oracle.
Check out the performance
One of the key advantages of a Ready Solution like the Ready Bundle is the Oracle performance testing we complete in our labs to ensure accurate sizing for your workloads. Testing starts with an Online Transactional Processing (OLTP) battery of tests to validate the solution. This test is optimized for ERP, CRM, and other systems of records applications. The goal of these tests is to evaluate system performance under a high volume of transactions in which response times remain under 1 millisecond.
In a recent VMAX Engineering white paper called, Dell EMC VMAX all-flash storage for mission-critical Oracle database the first test generated 275,626 IOPS across 32 SSD drives in a RAID5 configuration but response times remained under the gold standard of 1 millisecond. See figure 1.
Figure 1: Two-node Oracle RAC configuration driving over 275K IOPS with sub-millisecond latencies
Notice the speed of the average write times for data and log write operations. This is because the 1TB VMAX storage array cache is designed to immediately acknowledge all write quests thus, both data writes and log writes are at an outstanding .3 millisecond average response times.
What about data read response times? The massive number of IOPS generated in this test was done purposely to force the VMAX all flash array to read from the flash drives. This means most of the reads were not satisfied by the VMAX cache which is the worst case scenario. Even with the majority of reads satisfied from flash drives the average read response times were at .8 milliseconds.
Typically, production Oracle RAC systems do not generate nearly as many IOPS as was done with this test but, this does lead to another advantage of the Ready Bundle for Oracle in that it can easily support large database ecosystems and meet performance Service Level Agreements (SLA).
Let’s use a scenario of a database ecosystem consisting of production, quality assurance, test and sandbox. See figure 2 for the daily average IOPS for each of the databases.
Figure 2: Scenario of Oracle database ecosystem
Figure 2 shows the four databases account for 65,000 IOPS which is a fraction of what was done in our testing. Looking at it another way, it would take five times (20 databases) the number of databases to be nearly equivalent in IOPS in our test. This means the Ready Bundle for Oracle offers exceptional scalability for database workloads.
OLAP test results
The second type of database workload test was with Online Analytical Processing (OLAP) used for business intelligence, reporting, and data mining. OLAP uses de-normalized data, fewer tables, and longer queries that depend more throughput than response times. Let’s focus on the PowerEdge R940 server in terms of OLAP performance to provide a more thorough overview of the entire solution. The new 14th Generation PowerEdge R940 server was tested using OLAP / TCP-H-like tests with Oracle’s in-memory database option to evaluate processor performance. See figure 3 for test results.
Figure 3: Prior generation PowerEdge R930 compared to PowerEdge R940 in Oracle OLAP Tests
Looking at this graph, the lower the bar, the faster the average execution time of the queries. In the light OLAP test with one user and 22 queries, the R940 completed queries 52% faster than the R930! In the heavy OLAP test with seven users and 154 queries, the R940 completed 9% faster. There is another factor to this testing ─ the PowerEdge R940 was faster even though the server had 16 fewer processors than the R930! Dell EMC estimates using a new 14th generation PowerEdge R940 server with fewer faster processor could save customer on Oracle Licensing.
It’s the comprehensive performance testing of the Ready Bundle for Oracle that makes this optimized database solution ideal for ecosystems of all sizes. The PowerEdge R940 accelerates database workloads using fewer processors and the VMAX 250F provides a wealth of IOPS but more importantly response times under one millisecond. There is no integration work or risk as the Ready Bundle is delivered as a unified solution to the datacenter for DBAs teams to start using very quickly.
Tomorrow I will focus on the value of consolidation for databases and the capability for you to experience a big disk space savings using the Ready Bundle for Oracle. If you have any questions I’ll be in the Dell EMC booth at Oracle OpenWord 2017 or email me at Sam.Lucido@dell.com.