Microsoft SQL 2019 on Intel Optane Persistent Memory (PMem) Using Dell EMC PowerEdge Servers

• 1
  Solution description
• 2
  Document purpose
• 3
  Audience
• 4
  We value your feedback

• 1
  Overview
• 2
  Server layer
• 3
  Network layer
• 4
  Storage layer

• 1
  Intel Optane PMem module
• 2
  Microsoft SQL Server 2019

• 1
  Introduction
• 2
  App Direct Mode
• 3
  Memory Mode

• 1
  Introduction
• 2
  Configure the BIOS
• 3
  Configure RAID groups and storage
• 4
  Install the operating system
• 5
  Configure the network

• 1
  Introduction
• 2
  Configure SQL Server
• 3
  Move tempdb
• 4
  Create memory-optimized tables
• 5
  Tuned-adm Profile and other configuration guidelines
• 6
  Benchmarking configuration

• 1
  Introduction
• 2
  Physical server layer
• 3
  Operating system layer
• 4
  Database layer