White Papers

Recommended reference architectures
9 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
Highly available reference architecture details
Component
Description
Server
Two PowerEdge R640
Processors
Dual Intel
®
Xeon
®
Gold 6126 Processor (2.6GHz, 12 cores, 24 threads)
Total cores
24 per server
Total logical
processors
48 per server (Hyper-Threading Technology enabled)
Total memory
1024GB per server
Network
adapters
Public network: Minimum of two network adapters (1Gbps- or 10Gbps-
based requirements) per server with load balancing configured
Private network (cluster): Minimum of one network adapter with 1Gbps (or
more) connectivity per server
Host bus
adapters
Two QLogic QLE2662 dual-port 16Gbps FC HBAs per server
Software
Operating
system
Windows Server 2016 Standard Edition with Windows Failover Clustering
Database
software
SQL Server 2017 Enterprise Edition configured as a Failover Cluster
Instance
Storage
Array
PowerVault ME4024 (firmware: GT275R0003-01)
I/O cards
8 x 16Gbps FC ports (four per controller)
Disk drives
24 x 1.92TB SSDs (2.5-inch SAS)