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

Table of contents Table of contents Revisions...2 Acknowledgements ...2 Table of contents ...3 Executive summary...5 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 3 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL