Dell EMC PowerEdge R940 and SC9000 200TB Data Warehouse Fast Track Reference Architecture for SQL Server 2017

This paper describes the design principles and guidelines used to achieve an optimally balanced 200TB Data Warehouse Fast Track reference architecture for SQL Server 2017 using Dell EMC™ PowerEdge™ R940 servers and Dell EMC SC9000 arrays.


Dell EMC PowerEdge R940 and SC9000 200TB Data Warehouse Fast Track Reference Architecture for SQL Server 2017 - cover page
Brand
Dell EMC
Category
Servers Computer
Document type
Other
Language
English
Pages
25
File format
PDF
File size
1.1 MB
Published
25 November, 2023
Updated
25 November, 2023
MD5 checksum
14A973E902610E7879866520427B59DB

About this manual

This Dell EMC reference architecture paper describes the design principles and guidelines used to build an optimally balanced 200TB Data Warehouse Fast Track (DWFT) configuration for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 servers and Dell EMC SC9000 storage arrays. It was published in November 2018 as an initial release and is aimed at database administrators, business intelligence architects, storage administrators, IT directors and data warehousing users looking for sizing and design guidance.

The paper presents two recommended architectures, a single-server design and a highly available design, then details the hardware components (PowerEdge R940 server, QLogic QLE2662 16Gbps host bus adapter, Brocade 6505 SAN switch and SC9000 array) and the storage, server, Windows Server 2016 and SQL Server 2017 Enterprise Edition configuration settings. It also covers SQL Server 2017 column-store improvements, additional considerations for the highly available architecture, and DWFT certification.

What's inside

  • Microsoft SQL Server 2017 data warehousing and improved column-store technology
  • Recommended reference architectures
  • Single-server reference architecture
  • Highly available reference architecture
  • Hardware components
  • Storage configuration
  • Server configuration
  • Windows Server 2016 configuration
  • SQL Server 2017 Enterprise Edition configuration
  • Additional considerations for the highly available reference architecture

Specifications

Reference architecture capacity200TB
ServersDell EMC PowerEdge R940 (14th generation)
Storage arrays2 x Dell EMC SC9000
Additional storage2 x Dell Storage SC420
Host bus adapterQLogic QLE2662 16Gbps
SAN switchBrocade 6505
Operating systemWindows Server 2016
Database softwareMicrosoft SQL Server 2017 Enterprise Edition
Column-store compressionUp to 10X compression in data size

Frequently asked questions

What hardware is used in this 200TB data warehouse reference architecture?

It uses Dell EMC PowerEdge R940 servers together with Dell EMC SC9000 storage arrays, plus two Dell Storage SC420 systems in the single-server figure.

Who is the target audience for this reference architecture paper?

Database administrators, business intelligence architects, storage administrators, IT directors and data warehousing users seeking sizing and design guidance for SQL Server 2017 business intelligence solutions.

Who engineers and tests the Dell EMC DWFT reference architectures for SQL Server 2017?

They are engineered jointly by Dell EMC and Microsoft; Dell EMC tests the hardware and software optimizations and Microsoft crosschecks the performance results.

What compression does column-store technology provide for data warehouses?

The paper states column-store indices can provide up to 10X compression in data size, reducing space, cost and I/O requirements.

Download PDF (1.1 MB)

More Dell EMC Manuals


View all Dell EMC manuals →