Reference Architecture Guide—Consolidate and Simplify Mixed SQL Server and Oracle 18c Database Workloads

• 1
  Executive overview
• 2
  Audience and purpose
• 3
  Converged and Hyperconverged infrastructures
• 4
  Value of validated reference architectures
• 5
  Mixed database workloads
• 6
  We value your feedback
• 7
  Key validation testing goal
• 8
  Database backup and recovery
• 9
  Key benefits

• 1
  Solution architecture diagram
• 2
  PowerEdge MX7000 modular chassis
• 3
  PowerMax 2000 storage array
• 4
  Compute or server layer
• 5
  Data Domain DD9300 backup appliance
• 6
  Network Layer
• 7
  Redundancy

• 1
  Test goals and configuration
• 2
  Use case 1: OLTP workload using TPC-C–like benchmark
• 3
  Validated infrastructure configuration
• 4
  Use case 2: DSS workload using TPC-H–like benchmark
• 5
  NVMe
• 6
  Use case 3: Snapshot OLTP workload using TPC-C–like benchmark
• 7
  VMware vSphere
• 8
  Test performance metrics
• 9
  PowerMaxOS service levels
• 10
  Dell EMC Live Optics for data collection

• 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
• 4
  Storage and file system
• 5
  Mtree and storage unit
• 6
  IP network design
• 7
  RMAN backup and restore parameters
• 8
  Test methodology and results
• 9
  Use Case 1: First full backup of standalone OLTP database
• 10
  Use Case 2: Second full backup of the standalone OLTP database
• 11
  Use Case 3: Restore and recovery of the OLTP database from full backup

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

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

• 1
  Hardware components
• 2
  Software components
• 3
  Compute and network components
• 4
  Storage array
• 5
  DD9300 backup system

• 1
  Compute and network design
• 2
  Converged network adapter configuration
• 3
  ESXi virtual network design
• 4
  FCoE-to-FC connectivity and zoning
• 5
  Multipath configuration
• 6
  PowerMax storage configuration
• 7
  Storage groups and volumes for Oracle workloads
• 8
  Storage groups and volumes for SQL Server workloads
• 9
  Snapshot database volumes
• 10
  Oracle VMs and guest operating system configurations
• 11
  SCSI controllers and virtual hard disks
• 12
  vCPU, vMem, and vNIC configuration
• 13
  Enable disk UUID
• 14
  Guest operating system and Oracle ASM configuration
• 15
  SQL Server VMs and guest operating system configurations
• 16
  SCSI controllers and virtual hard disks
• 17
  vCPU, vMem, and vNIC configuration
• 18
  Enable disk UUID
• 19
  Guest operating system and SQL Server installation and configuration