Dell PowerEdge R940 Deploying the 385TB Data Warehouse Fast Track Reference Ar - Page 5

Solution requirements, Component, Description, Server, Software, Storage, Hardware component

Page 5 highlights

Solution requirements 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) Software Storage Host bus adapters Operating system Database software Storage array Disk drives SAN switches Recommended to have more than one network adapter with load balancing configured Eight QLogic® QLE2662 dual-port 16Gbps FC HBAs Microsoft Windows Server® 2016 Enterprise Edition SQL Server 2017 Enterprise Edition SC9000 (SCOS v7.3.2) 48 x 3.84TB read-intensive SSDs (2.5-inch SAS) 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 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
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25

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