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
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