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