White Papers

Solution requirements
5 Deploying the 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using
Dell EMC PowerEdge R940 and SC9000 | 4033-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 R940
Processors
Four Intel
®
Xeon
®
Platinum 8168 Processors (2.7GHz, 24 cores,
48 threads)
Total cores
96
Total logical
processors
192 (Intel Hyper-Threading Technology enabled)
Total memory
3072GB
Network adapters
Minimum of one network adapter (1Gbps or 10Gbps based on
requirements)
Recommended to have more than one network adapter with
load balancing configured
Host bus adapters
Eight QLogic
®
QLE2662 dual-port 16Gbps FC HBAs
Software
Operating system
Microsoft Windows Server
®
2016 Enterprise Edition
Database software
SQL Server 2017 Enterprise Edition
Storage
Storage array
SC9000 (SCOS v7.3.2)
Disk drives
48 x 3.84TB read-intensive SSDs (2.5-inch SAS)
SAN switches
Two Brocade
®
6505 with 16Gbps SFPs
Server firmware versions
Hardware component
Firmware version
BIOS
1.4.9
Backplane 1
3.56
Dell™ 64 Bit uEFI Diagnostics
4301A18
Dell OS Driver Pack
18.04.07,A00
Integrated Dell Remote Access Controller (iDRAC)
3.21.23.22
Broadcom
®
Gigabit 4P X520/l350 rNDC
20.8.4
Lifecycle Controller
3.21.23.22
OS Collector
3.0
Power supply
00.32.55
QLogic QLE2662
14.07.05
System CPLD
0.4.0
PowerEdge RAID Controller (PERC) H730P adapter
25.5.5.0005