Proof of Concept – Running Oracle and Microsoft SQL Databases on Dell APEX – Part 1
Wed, 31 May 2023 16:08:03 -0000
|Read Time: 0 minutes
Oracle and Microsoft SQL databases are critical components of most business operations. Most organizations have many Oracle and Microsoft SQL databases spread across on-premises and the cloud. Procuring the underlying infrastructure can pose a challenge to IT. These challenges can be minimized by using Dell APEX Private Cloud, Hybrid Cloud, or APEX Data Storage Services offerings.
What is Dell APEX?
Dell APEX is a portfolio of Dell Technologies as-a-Service offerings simplify digital transformation by increasing IT agility and control. It gives customers a seamless IT experience by delivering infrastructure, devices, and applications as-a-Service. Customers have the freedom to scale resources up or down quickly to react to their business requirements. Dell APEX makes it easier than ever to unlock the full potential of multicloud, allowing customers to capitalize on cloud experiences and have access to best-in-class technologies to drive innovation. Dell APEX gives customers control of the security, access, and location of their data.
Why run Oracle and Microsoft SQL Databases on Dell APEX?
Traditionally, building an infrastructure solution for mission-critical databases such as Oracle and Microsoft SQL can be a time-consuming and complex process because running these databases in production demands high performance, high availability, and elasticity. Technologies and lines of business are constantly changing, which makes it difficult for IT to forecast infrastructure requirements. CAPEX and time-to-market (TTM) must also be evaluated.
To solve these challenges, IT architects are often required to work with business stakeholders on a regular cadence to build the right software and hardware technologies to enable business growth and minimize complexities. Because hardware technology enhancements are developing rapidly, the technology refresh also needs to be aligned. This technology refresh requires IT architects to research, procure, and test the technology as soon as possible in this never-ending process.
The reason to upkeep with the latest hardware technology is because mission-critical applications running on Oracle or Microsoft SQL databases require zero downtime for a business to be successful. Even a brief outage of a mission-critical application is likely to have negative financial consequences.
With Dell APEX, customers only focus on business outcomes and not the infrastructure. Dell APEX delivers as-a-Service solutions which offer a core set of capabilities from deployment to ongoing infrastructure monitoring, operations, optimization, and support. It provides customers a seamless experience to manage their entire cloud and as-a-service journey. Customers can easily browse a selection of as-a-Service/cloud solutions and then place an order for their business. Customers can also deploy workloads, manage their multicloud resources, monitor their costs in real-time, and add cloud services, all with a few clicks.
Proof of concept
The Dell Solutions Engineers deployed both Oracle and Microsoft SQL database workloads to demonstrate the Dell APEX Cloud offerings. Since Dell APEX offers infrastructure as-a-Service, the Solutions Engineers focused on business outcomes for Oracle and Microsoft SQL workloads. The business outcomes for this proof of concept are the number of New Orders Per Minute (NOPM) and the number of Transactions Per Minute (TPM). These requirements simulate a retail business where customers can order new products online. The requirements for Oracle and Microsoft SQL workloads are around 120,000 NOPM and around 300,000 TPM.
The Solutions Engineers requested an infrastructure as-a-Service from the APEX team that would meet these workload requirements through the APEX console.
Because this exercise was based on the private cloud model, the Dell APEX team delivered a pre-engineered solution that was optimized for database workloads. The Dell APEX Private Cloud with APEX Data Storage Services infrastructure provide a seamless, curated, and optimized production-ready solution, meaning it consists of necessary components not just for the requirements but also includes backup and recovery. The Solutions Engineers were given access to start deploying virtual machines, installing operating systems, configuring storage devices, and installing and configure Oracle and Microsoft databases.
Another approach to running workloads on Dell APEX is to migrate existing Oracle and Microsoft SQL databases on to the Dell APEX Private Cloud infrastructure. This option not only enables customers to easily migrate existing virtual machines configurations to Dell APEX, reducing setup time and enabling the business quicker time-to-market, but also provides a level of confidence to the customers knowing that their existing VMs configurations were performing adequately before moving to the APEX Private Cloud.
To accomplish this proof of concept, the Solutions Engineers copied the Oracle and Microsoft SQL OVA archive files from their existing environment to the new Dell APEX Private Cloud infrastructure and spun up the VMs. After the database VMs were successfully up and running, the engineers used an open-source benchmark tool called HammerDB to simulate an Online Transaction Processing (OLTP) workload against both Oracle and Microsoft SQL databases. Table 1 shows the VMs configurations.
Table 1. Database VMs Configurations
| Workloads | # of VMs | # of vCPU | Memory |
|---|---|---|---|
Oracle | 1 | 6 | 192 GB |
Microsoft SQL | 1 | 10 | 112 GB |
The HammerDB benchmark tool was used to simulate the retail business example stated above. The below table shows the HammerDB workload configuration.
Table 2. HammerDB Workload Settings
| Setting name | Value |
|---|---|
Total transactions per user | 10,000,000 |
Number of warehouses | 10,000 |
Minutes of ramp up time | 10 |
Minutes of test duration | 50 |
Use all warehouses | Yes |
No. of virtual users | 80 |
User delay (ms) | 500 |
Repeat delay (ms) | 500 |
Iterations | 1 |
To ensure results consistency, multiple iterations of the OLTP workload benchmark were performed. The final test results derived from the average of three tests. Table 3 below shows the results for the NOPM and TPM for Oracle and Microsoft SQL workloads.
Table 3. Workloads results
| Workloads | NOPM | TPM |
|---|---|---|
Oracle | 147,874 | 313,130 |
Microsoft SQL | 130,824 | 300,978 |
Summary
Based on these results, we are confident that when we subscribe to Dell APEX offerings we will achieve the desired outcomes. With Dell APEX, the Solutions Engineers did not spend time on researching or validating what hardware to procure for these workloads but instead they just used the Dell APEX console and subscribe to resources already engineered to meet the business requirements.
In the next blog we are going to fully populate an APEX Private Cloud and APEX Data Storage Services subscription with Oracle and Microsoft SQL workloads in order to show how well it handles a demanding workload.
Additional resources
Containerized Microsoft SQL Server on Dell Technologies APEX