White Papers

Solution requirements
5 Deploying the 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 4023-CD-SQL
1 Solution requirements
This section lists the hardware and software components required to implement the single-server reference
architecture. The versions of firmware on the server used to validate the reference architecture are also listed.
Hardware and software components
Component
Description
Server
PowerEdge R640
Processors
Dual Intel
®
Xeon
®
Gold 6126 Processor (2.6 GHz, 12 cores, 24
threads)
Total cores
24
Total logical
processors
48 (Hyper-Threading Technology enabled)
Total memory
896 GB
Network
adapters
Minimum of one network adapter (1 Gbps or 10 Gbps based on
requirements)
Recommended to have more than one network adapter with load
balancing configured
Host bus
adapters
Two QLogic
®
QLE2662 dual-port 16 Gbps FC HBA
Software
Operating
system
Microsoft Windows Server
®
2016 Standard Edition
Database
software
SQL Server 2017 Enterprise Edition
Storage
Array
PowerVault ME4024 (firmware: GT275R0003-01)
Front-end I/O
ports
8 x 16 Gbps FC ports (four per controller)
Disk drives
24 x 1.92 TB SSDs (2.5" SAS)
Server firmware versions
Hardware component
Firmware version
BIOS
1.4.9
Backplane 1
4.26
Dell™ 64 Bit uEFI Diagnostics
4301X09
Dell OS Driver Pack
18.04.07
Integrated Dell Remote Access Controller
3.21.21.21
Intel
®
Ethernet 10G 4P X520/l350 rNDC
18.5.17