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

Dell PowerEdge R640 Deploying the 55TB Data Warehouse Fast Track Reference Arc - Page 2

Revisions, Acknowledgements, Description

View all Dell PowerEdge R640 manuals

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

Page 2 highlights

Revisions Revisions Date September 2018 Description Initial release Acknowledgements Author: Doug Bernhardt The information in this publication is provided "as is." Dell Inc. makes no representations or warranties of any kind with respect to the information in this publication, and specifically disclaims implied warranties of merchantability or fitness for a particular purpose. Use, copying, and distribution of any software described in this publication requires an applicable software license. © 2018 Dell Inc. or its subsidiaries. All Rights Reserved. Dell, EMC, Dell EMC and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be trademarks of their respective owners. Dell believes the information in this document is accurate as of its publication date. The information is subject to change without notice. 2 Deploying the 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL

Section	Page
1 Solution requirements	5
2 Deployment workflow	7
3 Cabling requirements	8
4 Configure the PowerVault ME4024 storage array	9
4.1 Configure local ports	9
4.2 Configure disks	9
4.3 Create the host and volumes	9
5 Configure the PowerEdge R640 server	11
5.1 Update the firmware	11
5.2 Configure the system BIOS	11
5.3 Reset the HBAs to default settings	12
5.4 Configure the HBAs	12
6 Install and configure Windows Server 2016	13
6.1 Install Windows Server 2016	13
6.2 Configure 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 Set the Power Plan	15
6.2.9 Remove SMBv1 (optional)	16
6.2.10 Configure Windows Updates (optional)	16
6.2.11 Create a local SQL Server service account	16
6.2.12 Lock pages in memory	16
6.2.13 Change the optical drive letter (optional)	17
6.2.14 Configure the Windows Firewall	17
6.3 Configure the Windows volumes	17
6.3.1 Map and format the remaining volumes.	17
7 Install and configure SQL Server 2017 Enterprise Edition	19
7.1 Install SQL Server 2017 Enterprise Edition	19
7.2 Install SQL Server Management Studio (optional)	20
7.3 Configure SQL Server 2017 Enterprise Edition	20
7.3.1 Open SQL Server Management Studio	20
7.3.2 Turn on advanced configuration options	20
7.3.3 Set SQL Server maximum memory	21
7.3.4 Configure the resource governor	21
7.3.5 Expand tempdb files	22
8 Verify the deployment	23
A Technical support and resources	24

Match case Limit results 1 per page

Revisions

Deploying the 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using

Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL

Revisions

Date

Description

September 2018

Initial release

Acknowledgements

Author: Doug Bernhardt

The information in this publication is provided “as is.” Dell Inc. makes no representations or warranties of any kind with respect to the information in this

publication, and specifically disclaims implied warranties of merchantability or fitness for a particular purpose.

Use, copying, and distribution of any software described in this publication requires an applicable software license.

trademarks may be trademarks of their respective owners.

Dell believes the information in this document is accurate as of its publication date. The information is subject to change without notice.