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

• 1

  Solution description
• 2

  Document purpose
• 3

  Audience
• 4

  We value your feedback

• 1

  Solution architecture
• 2

  Server layer
• 3

  Network layer
• 4

  Storage layer

• 1

  Intel Optane PMem module
• 2

  Microsoft SQL Server 2019

• 1

  Use cases and considerations
• 2

  App Direct Mode
• 3

  Memory Mode

• 1

  Setting up and configuring the solution deployment
• 2

  Configure the BIOS
• 3

  Configure RAID groups and storage
• 4

  Install the operating system
• 5

  Configure the network

• 1

  Installing SQL Server
• 2

  Configure SQL Server
• 3

  Move tempdb
• 4

  Create memory-optimized tables
• 5

  Tuned-adm Profile and other configuration guidelines
• 6

  Benchmarking configuration

• 1

  Recommendations and best practices
• 2

  Physical server layer
• 3

  Operating system layer
• 4

  Database layer