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

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

A Technical support and resources, Related documentation

View all Dell PowerEdge R940 manuals

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

Page 25 highlights

Technical support and resources A A.1 Technical support and resources Dell.com/support is focused on meeting customer needs with proven services and support. Storage technical documents and videos provide expertise that helps to ensure customer success on Dell EMC storage platforms. Related documentation See the following referenced or recommended resources related to this document: • Dell SQL Server Solutions • Dell Data Warehouse Fast Track for SQL Server Advisor • 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000, available at SC Series technical documents 25 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