Reference Architecture Guide—Consolidate and Simplify Mixed Database Workloads

• 1
  Executive overview
• 2
  Audience and purpose
• 3
  Value of validated reference architectures
• 4
  We value your feedback

• 1
  Solution architecture diagram
• 2
  PowerEdge MX7000 modular chassis
• 3
  PowerMax 2000 storage array
• 4
  Data Domain DD9300 backup appliance
• 5
  Redundancy

• 1
  Test goals and configuration
• 2
  Use case 1: OLTP workload using TPC-C–like benchmark
• 3
  Use case 2: DSS workload using TPC-H–like benchmark
• 4
  Use case 3: Snapshot OLTP workload using TPC-C–like benchmark
• 5
  PowerMaxOS service levels

• 1
  Overview
• 2
  Average CPU utilization
• 3
  TPM
• 4
  NOPM
• 5
  Storage IOPS
• 6
  Storage latency
• 7
  Throughput
• 8
  Combined performance of IOPS, latency, and throughput

• 1
  Introduction
• 2
  Backup and recovery solution for Oracle
• 3
  Backup and recovery solution for SQL Server

• 1
  Performance at scale
• 2
  PowerEdge MX840c performance findings
• 3
  PowerMax 2000 performance findings
• 4
  Data Domain backup and recovery findings
• 5
  Results summary

• 1
  Dell EMC documentation
• 2
  VMware documentation
• 3
  Oracle documentation
• 4
  Microsoft documentation
• 5
  HammerDB documentation

• 1
  Hardware components
• 2
  Software components

• 1
  Compute and network design
• 2
  PowerMax storage configuration
• 3
  Oracle VMs and guest operating system configurations
• 4
  SQL Server VMs and guest operating system configurations