Home » Dell Manuals » Servers » Dell PowerEdge R940 » Manual Viewer

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

Deployment workflow, servers, Microsoft SQL Server, and SC Series arrays.

View all Dell PowerEdge R940 manuals

Add to My Manuals
Save this manual to your list of manuals

Page 6 highlights

Deployment workflow 2 Deployment workflow This section outlines the sequence of deploying the 385TB Data Warehouse Fast Track for SQL Server 2017 reference architecture using the PowerEdge R940 server and SC9000 storage array. To deploy the reference architecture, perform the following tasks: 1. Configure the SC9000 storage array. 2. Configure the PowerEdge R940 server. 3. Install and configure the Windows Server 2016 operating system. 4. Install and configure SQL Server 2017 Enterprise Edition. This guide assumes the reader has a general understanding of installing and configuring Microsoft Windows servers, Microsoft SQL Server, and SC Series arrays. 6 Deploying the 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4033-CD-SQL

Section	Page
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.2.1 Set the server name (optional)	14
6.2.2 Set the IP address (optional)	14
6.2.3 Enable Remote Desktop (RDP) (optional)	14
6.2.4 Install the Multipath I/O feature	14
6.2.5 Remove install disk	15
6.2.6 Set the time zone of the server (optional)	15
6.2.7 Configure MPIO	15
6.2.8 Apply MPIO best practices	15
6.2.9 Set the Power Plan	15
6.2.10 Remove SMBv1 (optional)	16
6.2.11 Configure Windows Updates (optional)	16
6.2.12 Create a local SQL Server service account	16
6.2.13 Lock pages in memory	16
6.2.14 Change the optical drive letter (optional)	17
6.2.15 Configure the Windows Firewall	17
6.3 Configure the Windows volumes	17
6.3.1 Change the operating system definition in the SC Series array	17
6.3.2 Map and format the volumes.	18
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
7.3.1 Open SQL Server Management Studio	21
7.3.2 Turn on advanced configuration options	21
7.3.3 Set SQL Server maximum memory	22
7.3.4 Set the max degree of parallelism (MAXDOP)	22
7.3.5 Configure the resource governor	22
7.3.6 Expand tempdb files	23
8 Verify deployment	24
A Technical support and resources	25