Reference Architecture Guide—Ready Solutions for Microsoft SQL: Design for Dell EMC XtremIO

• 1
  Reference architecture overview
• 2
  Audience
• 3
  We value your feedback

• 1
  Physical architecture diagram
• 2
  Server layer
• 3
  Network layer
• 4
  Storage layer

• 1
  Logical architecture diagram
• 2
  Test environments

• 1
  Overview
• 2
  Hardware components
• 3
  Software components

• 1
  ESXi host configuration
• 2
  Multipathing configuration
• 3
  FC fabric connectivity and zoning
• 4
  Virtual network design
• 5
  Virtual machine configuration
• 6
  Guest operating system configuration
• 7
  SQL Server configuration
• 8
  Storage layout

• 1
  Introduction
• 2
  Infrastructure configuration
• 3
  Dell EMC XtremIO X2
• 4
  Data collection
• 5
  OLTP use case
• 6
  Peak CPU utilization
• 7
  Average IOPS
• 8
  Read and write latency
• 9
  Storage latency
• 10
  Combined performance of IOPS and latency
• 11
  Database consolidation
• 12
  XtremIO X2 inline data reduction

• 1
  Consolidation benefits
• 2
  Consulting and support

• 1
  Dell EMC documentation
• 2
  VMware documentation
• 3
  Microsoft documentation

• 1
  Introduction
• 2
  Physical server layer
• 3
  Storage layer
• 4
  Virtualization layer
• 5
  Operating system layer
• 6
  Database layer

• 1
  Configuring the ESXi management network
• 2
  Creating a vSphere datacenter
• 3
  Creating a virtual network

• 1
  Introduction
• 2
  Configuring volumes on the XtremIO X2 array
• 3
  Discovering LUNs in vCenter
• 4
  Creating a VM
• 5
  Creating SCSI controllers
• 6
  Adding a datastore to a VM