White Papers

ManualsBrandsDell ManualsCompellent (SCStorage SC9000

Table of contents

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

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