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

Component, Description

Page 10 highlights

Recommended reference architectures Highly available reference architecture details Component Description Server Two PowerEdge R940 Processors Four Intel® Xeon® Platinum 8168 Processors (2.7GHz, 24 cores, 48 threads) Total cores 96 per server Total logical processors 192 per server (Hyper-Threading Technology enabled) Total memory 3072GB 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 Software Storage Host bus adapters Operating system Database software Array I/O cards Eight QLogic QLE2662 dual-port 16Gbps FC HBAs per server Windows Server 2016 Enterprise Edition with Windows Failover Clustering SQL Server 2017 Enterprise Edition configured as a Failover Cluster Instance SC9000 (SCOS v7.3.2) Four QLogic QLE2694 quad-port 16Gbps FC HBAs (two per controller) Disk drives 48 x 3.84TB read-intensive SSDs (2.5-inch SAS) SAN switches Two Brocade 6505 with 16Gbps SFPs 10 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
10
385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R940 and SC9000 | 4032-RA-SQL
Highly available reference architecture details
Component
Description
Server
Two PowerEdge R940
Processors
Four Intel
®
Xeon
®
Platinum 8168 Processors (2.7GHz, 24 cores, 48
threads)
Total cores
96 per server
Total logical
processors
192 per server (Hyper-Threading Technology enabled)
Total memory
3072GB 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
Eight QLogic QLE2662 dual-port 16Gbps FC HBAs per server
Software
Operating
system
Windows Server 2016 Enterprise Edition with Windows Failover Clustering
Database
software
SQL Server 2017 Enterprise Edition configured as a Failover Cluster
Instance
Storage
Array
SC9000 (SCOS v7.3.2)
I/O cards
Four QLogic QLE2694 quad-port 16Gbps FC HBAs (two per controller)
Disk drives
48 x 3.84TB read-intensive SSDs (2.5-inch SAS)
SAN switches
Two Brocade 6505 with 16Gbps SFPs