White Papers

Recommended reference architectures
8 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
2.2 Highly available reference architecture
For database high availability, Windows
®
failover clustering is recommended. Using Microsoft clustering
services, one database server is configured as the primary (active) server and the second server is
configured as the secondary (passive) server. The secondary server should have exactly the same
configuration as the primary server. Since the database is only active on a single server at any point of time,
the performance of the database on the primary server (active) is comparable to the single server
configuration (discussed earlier).
Figure 2 illustrates the highly available reference architecture with its major elements and Table 2 lists the
component details.
Highly available reference architecture