Dell PowerEdge R940 Deploying the 385TB Data Warehouse Fast Track Reference Ar - Page 3

Table of contents Table of contents Revisions...2 Acknowledgements ...2 Table of contents ...3 Overview ...4 1 Solution requirements ...5 2 Deployment workflow ...6 3 Cabling requirements ...7 4 Configure SC9000 storage array...8 4.1 Configure local ports...8 4.2 Configure disks ...8 4.3 Configure storage type ...8 4.4 Allow storage profile selection ...8 4.5 Create RAID 5 All Tiers storage profile ...8 4.6 Create server object ...9 4.7 Remove default snapshot profiles ...9 4.8 Create volumes...10 5 Configure PowerEdge R940 server...11 5.1 Update firmware ...11 5.2 Configure System BIOS ...11 5.3 Reset HBAs to default settings...12 5.4 Configure HBAs ...12 6 Install and configure Microsoft Windows Server 2016 13 6.1 Install Microsoft Windows Server 2016 ...13 6.2 Configure Microsoft Windows Server 2016 ...13 6.3 Configure the Windows volumes ...17 7 Install and configure Microsoft SQL Server 2017 Enterprise Edition 20 7.1 Install Microsoft SQL Server 2017 Enterprise Edition 20 7.2 Install SQL Server Management Studio (optional 21 7.3 Configure Microsoft SQL Server 2017 Enterprise Edition 21 8 Verify deployment...24 A Technical support and resources ...25 3 Deploying the 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4033-CD-SQL