Dell PowerEdge R640 55TB Data Warehouse Fast Track Reference Architecture for - Page 8

Recommended reference architectures 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 8 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL