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