Dell PowerEdge R940 385TB Data Warehouse Fast Track Reference Architecture for - Page 8

Component, Description, Server, Software, Storage, Hardware component, Firmware version

Page 8 highlights

Recommended reference architectures Single-server reference architecture details 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) Software Storage Recommended to have more than one network adapter with load balancing configured Host bus adapters Eight QLogic® QLE2662 dual-port 16Gbps FC HBAs Operating system Microsoft Windows Server® 2016 Enterprise Edition Database software SQL Server 2017 Enterprise Edition 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 BIOS Backplane 1 Dell™ 64 Bit uEFI Diagnostics Dell OS Driver Pack Integrated Dell Remote Access Controller (iDRAC) Broadcom® Gigabit 4P X520/l350 rNDC Lifecycle Controller OS Collector Power supply QLogic QLE2662 System CPLD PowerEdge RAID Controller (PERC) H730P adapter Firmware version 1.4.9 3.56 4301A18 18.04.07,A00 3.21.23.22 20.8.4 3.21.23.22 3.0 00.32.55 14.07.05 0.4.0 25.5.5.0005 8 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25

Recommended reference architectures
8
385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R940 and SC9000 | 4032-RA-SQL
Single-server reference architecture details
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