Scaling SQL Server 2022 VMs on Dell Integrated System for Microsoft Azure Stack HCI

• 1

  Executive summary
• 2

  Document purpose
• 3

  Audience

• 1

  Market environment
• 2

  Aging, inflexible infrastructure
• 3

  Shrinking budgets
• 4

  Operational inefficiencies

• 1

  Using a consultative approach to sizing
• 2

  Automation for operational efficiency
• 3

  New features in Microsoft SQL Server 2022

• 1

  Component details
• 2

  Storage layer architecture
• 3

  Network layer architecture

• 1

  Deployment overview
• 2

  Storage recommendations
• 3

  Networking recommendations
• 4

  Remote Direct Memory Access VM deployment and sizing recommendations
• 5

  SQL Server recommendations

• 1

  Benchmark testing methodology
• 2

  Benchmarking results
• 3

  Transactions Per Minute (TPM) and New Orders Per Minute (NOPM)
• 4

  CPU and storage parameters
• 5

  Azure Portal connectivity
• 6

  Scaling out Azure Stack HCI Nodes
• 7

  HA for SQL Server databases

• 1

  Conclusion
• 2

  Considerations
• 3

  We value your feedback