White Papers
Table Of Contents
- 1 Microsoft SQL Server 2017: Data warehousing with improved column-store technology
- 2 Recommended reference architectures
- 3 Hardware components
- 4 Storage configuration
- 5 Server configuration
- 6 Windows Server 2016 configuration
- 7 SQL Server 2017 Enterprise Edition configuration
- 8 Additional considerations for the highly available reference architecture
- 9 DWFT for SQL Server 2017 certification
- 10 Summary
- A Technical support and resources
Additional considerations for the highly available reference architecture
19 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL
8 Additional considerations for the highly available reference
architecture
The highly available (HA) reference architecture leverages Windows Failover Clustering to achieve high
availability. When configuring a Windows failover cluster, there are additional storage considerations:
• The recommended quorum configuration is to allow all cluster nodes to have quorum votes and use a
disk witness. An additional volume needs to be created and configured as the disk witness. Dell EMC
recommends using a 2GB volume for the disk witness. For more information on quorum and voting
configurations in a failover cluster, see the Microsoft article, Configure and manage quorum.
• All volumes need to be mapped to each node of the cluster.
• All volumes need to be configured as a cluster resource and added to the SQL Server cluster
resource group.