The Validated Design team at Dell EMC consists of a group of experts with extensive experience in databases. Our goal is to create focused solutions for the most challenging workloads that a business might require. That is uniquely different than most of today’s solutions, which are designed to work with everything. To increase the value to our customers, we validated our solutions by running multiple tests:
- We ran SQL Server and Oracle OLTP databases on the reference architecture in parallel.
- We ran OLTP and DSS workloads from both databases on the reference architecture in parallel.
- We tested the PowerMax snapshot capability by creating snapshots of both databases and running an OLTP workload on the snapshots.
- We tested DD Boost and the DD9300 system’s performance and capacity for backing up and restoring a 1.8 TB Oracle database.
As part of the validation tests, we tuned and optimized all the software and hardware components of this reference architecture to maximize performance. We documented as best practices in this guide any changes that we made that improved performance.
This reference architecture benefits customers by providing:
- A specialized database solution—No one size fits all. This reference architecture has been designed, tested, and validated especially for mixed database workloads.
- Database validation tests—We ran tests using the executables that customers would use to run their databases. No database I/O was simulated in this testing.
- Sizing to match requirements—You can customize the tested configuration to meet your mixed database workload needs.
- Tested, proven backup and recovery solution—Be prepared for unplanned database failures and minimize costly downtime.
- Less risk—We integrated, tested, and documented this validated system.
We used the HammerDB benchmarking tool to create OLTP and DSS workloads on the new database solution. HammerDB is free and available for anyone to use in conducting their own testing.