Dell APEX Block Storage for Azure: SQL Server 2022 Multi-Subnet Failover Clustering Deployment and 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

  SQL Server 2022 multi-subnet failover cluster on Dell APEX Block Storage for Azure
• 2

  Network architecture
• 3

  Logical architecture

• 1

  Overview
• 2

  Prerequisites
• 3

  Install Windows failover cluster roles and features
• 4

  Install Dell APEX Block Storage SDC
  • Provision the APEX Block Storage volume
  • Map the volumes to the Windows host
  • Initialize and format the disks

• 1

  Failover cluster validation wizard
• 2

  Create Windows Server 2022 multi-subnet Cluster

• 1

  Configure the first SQL Server 2022 node of the cluster
• 2

  Adding a second SQL Server 2022 node to the cluster
• 3

  Adding a third SQL Server 2022 node to the cluster
• 4

  Validate SQL Server 2022 multi-subnet failover cluster functionality
• 5

  Validate shutdown of active SQL server node

• 1

  Storage Resilience
• 2

  Validate AZ failure

• 1

  Overview
• 2

  Dell APEX Block Storage for Azure
• 3

  SQL Server database on Azure
• 4

  SQL Server database tuning considerations

• 1

  Conclusion

• 1

  APEX Block Storage SDS instance using Azure VM
• 2

  APEX Block Storage SDC instance using Azure VM
• 3

  APEX Block Storage gateway and presentation server
• 4

  HammerDB Instances

• 1

  Dell APEX Block Storage for Azure