Dell EMC 65TB DWFT Reference Architecture for SQL Server 2017 (PowerEdge R640, PowerVault ME4024)

A Dell EMC Reference Architecture 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 Configuration and performance results.


Dell EMC 65TB DWFT Reference Architecture for SQL Server 2017 (PowerEdge R640, PowerVault ME4024) - cover page
Brand
Dell EMC
Category
Servers Computer
Document type
Other
Language
English
Pages
22
File format
PDF
File size
1.1 MB
Published
25 November, 2023
Updated
25 November, 2023
MD5 checksum
18A2644FE57AC68097DA2BDFA6F80BB1

About this manual

This document describes design principles and configuration guidelines for a 65TB Data Warehouse Fast Track reference architecture for Microsoft SQL Server 2017. It covers single-server and highly available configurations using Dell EMC PowerEdge R640 servers and PowerVault ME4024 storage.

It details hardware, storage, server, Windows Server 2016, and SQL Server 2017 Enterprise Edition settings, plus certification and support information.

What's inside

  • Executive summary
  • Microsoft SQL Server 2017 data warehousing
  • Recommended reference architectures
  • Hardware components
  • Storage configuration
  • Server configuration
  • Windows Server 2016 configuration
  • SQL Server 2017 Enterprise Edition configuration
  • Highly available reference architecture
  • DWFT certification

Specifications

Server processorDual Intel Xeon Gold 6126 (2.6GHz, 12 cores, 24 threads)
Total cores24
Total logical processors48 (Hyper-Threading Technology enabled)
Total memory1024GB
Host bus adaptersTwo QLogic QLE2662 dual-port 16Gbps FC HBAs
Storage drives24 x 1.92TB SSDs (2.5-inch SAS)
Array front-end ports8 x 16Gbps FC ports (four per controller)
Array firmwareGT275R0003-01

Frequently asked questions

What operating system does the reference architecture use?

It uses Microsoft Windows Server 2016 Standard Edition.

What database software is used?

It uses SQL Server 2017 Enterprise Edition.

How many SSDs are in the PowerVault ME4024 array?

The array uses 24 x 1.92TB SSDs (2.5-inch SAS).

Who is the target audience?

Database administrators, business intelligence architects, storage administrators, IT directors, and data warehousing users.

Download PDF (1.1 MB)

More Dell EMC Manuals


View all Dell EMC manuals →