White Papers

Recommended reference architectures
7 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL
Single-server reference architecture details
Component
Description
Server
PowerEdge R640
Processors
Dual Intel
®
Xeon
®
Gold 6126 Processor (2.6GHz, 12 cores, 24
threads)
Total cores
24
Total logical
processors
48 (Hyper-Threading Technology enabled)
Total memory
1024GB
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
Two QLogic
®
QLE2662 dual-port 16Gbps FC HBAs
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 16Gbps FC ports (four per controller)
Disk drives
24 x 1.92TB SSDs (2.5-inch SAS)