Dell APEX Block Storage for AWS: Microsoft SQL Server 2022 on Linux with Multi-AZ Resiliency

• 1

  Executive summary

• 1

  Introduction
• 2

  Revisions
• 3

  Audience
• 4

  Terminology
• 5

  We value your feedback

• 1

  Dell APEX Block Storage for Public Cloud
• 2

  Multiple availability zones

• 1

  Microsoft SQL Server 2022 on Linux with Multi-AZ resiliency
• 2

  Network architecture
• 3

  Logical architecture
• 4

  PowerFlex architecture using Amazon Public Cloud

• 1

  Solution overview
• 2

  Install Dell APEX Block Storage SDC
• 3

  Provision APEX Block Storage volume
  • Map volumes
  • Review the LVM status information
  • Host entry

• 1

  Install SQL Server 2022
  • Installation of the SQL Server HA package
  • SQL Server configuration
• 2

  Pacemaker cluster installation and configuration
  • Create the PCS FCI resource
• 3

  Validate the SQL Server 2022 multi-subnet cluster failover functionality

• 1

  Storage resilience
• 2

  Validate AZ failure

• 1

  Best practices
• 2

  Dell APEX Block Storage for AWS
• 3

  SQL Server database on AWS
• 4

  SQL Server database tuning considerations

• 1

  Conclusion

• 1

  APEX Block Storage SDS instance using Amazon EBS
• 2

  PowerFlex SDC instance using Amazon EBS
• 3

  PowerFlex Manager
• 4

  HammerDB Instances

• 1

  Dell Technologies documentation
• 2

  AWS documentation
• 3

  Pacemaker documentation