Dell PowerEdge R940 385TB Data Warehouse Fast Track Reference Architecture for - Page 9

Recommended reference architectures 2.2 Highly available reference architecture For database high availability, Microsoft 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 in section 2.1). Figure 2 illustrates the highly available reference architecture with the major elements. Table 33 lists the component details. PPuubblliicc Nneettwwoorrk Private network Dell EMC PowerEdge R940 Brocade 6505 04 15 26 37 8 12 9 13 10 14 11 15 16 20 17 21 18 22 19 23 Brocade 6505 Dell EMC PowerEdge R940 Brocade 6505 04 15 26 37 8 12 9 13 10 14 11 15 16 20 17 21 18 22 19 23 Brocade 6505 2 x Dell EMC SC9000 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Highly available reference architecture 2 x Dell Storage SC420 9 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL