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

Table of contents

4

385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC

PowerEdge R940 and SC9000 | 4032-RA-SQL

7.3

Max degree of parallelism (MAXDOP)

.............................................................................................................

21

7.4

Resource governor

...........................................................................................................................................

21

7.5

Database configuration

.....................................................................................................................................

21

7.6

Tempdb configuration

.......................................................................................................................................

21

8

Additional considerations for the highly available reference architecture

..................................................................

22

9

DWFT for SQL Server 2017 certification

....................................................................................................................

23

10

Summary

....................................................................................................................................................................

24

A

Technical support and resources

...............................................................................................................................

25

Section	Page
1 Microsoft SQL Server 2017: Data warehousing with improved column-store technology	6
1.1 Dell EMC Data Warehouse Fast Track reference architectures for SQL Server 2017	6
2 Recommended reference architectures	7
2.1 Single-server reference architecture	7
2.2 Highly available reference architecture	9
3 Hardware components	11
3.1 PowerEdge R940 server	11
3.2 QLogic QLE2662 16Gbps host bus adapter	11
3.3 Brocade 6505 SAN switch	11
3.4 SC9000 array	11
4 Storage configuration	13
4.1 Cabling	13
4.2 I/O ports	14
4.3 Disk folder	14
4.4 Storage type	14
4.5 SC Series storage profiles	14
4.6 Read and write cache	15
4.7 SC Series server object	15
4.8 SC Series volumes	15
5 Server configuration	17
5.1 System BIOS	17
5.2 Host bus adapters	17
6 Windows Server 2016 configuration	18
6.1 Power plan	18
6.2 Lock pages in memory	18
6.3 Windows volumes	18
6.4 MPIO	20
7 SQL Server 2017 Enterprise Edition configuration	21
7.1 Grant perform volume maintenance task privilege	21
7.2 SQL Server maximum memory	21
7.3 Max degree of parallelism (MAXDOP)	21
7.4 Resource governor	21
7.5 Database configuration	21
7.6 Tempdb configuration	21
8 Additional considerations for the highly available reference architecture	22
9 DWFT for SQL Server 2017 certification	23
10 Summary	24

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

TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC

Page 4 highlights