White Papers

Recommended reference architectures
9 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R940 and SC9000 | 4032-RA-SQL
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.
Dell EMC
PowerEdge R940
Brocade 6505
2 x Dell EMC SC9000
Brocade 65 05
23
19
22
18
21
17
20
16
15
11
14
10
13
9
12
8
7
3
6
2
5
1
4
0
0 231 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
2 x Dell Storage SC420
Public
Network
Brocade 65 05
23
19
22
18
21
17
20
16
15
11
14
10
13
9
12
8
7
3
6
2
5
1
4
0
0 231 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Public
network
Brocade 6505
Dell EMC
PowerEdge R940
Private
network
Highly available reference architecture