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.
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.
| Server processor | Dual Intel Xeon Gold 6126 (2.6GHz, 12 cores, 24 threads) |
|---|---|
| Total cores | 24 |
| Total logical processors | 48 (Hyper-Threading Technology enabled) |
| Total memory | 1024GB |
| Host bus adapters | Two QLogic QLE2662 dual-port 16Gbps FC HBAs |
| Storage drives | 24 x 1.92TB SSDs (2.5-inch SAS) |
| Array front-end ports | 8 x 16Gbps FC ports (four per controller) |
| Array firmware | GT275R0003-01 |
It uses Microsoft Windows Server 2016 Standard Edition.
It uses SQL Server 2017 Enterprise Edition.
The array uses 24 x 1.92TB SSDs (2.5-inch SAS).
Database administrators, business intelligence architects, storage administrators, IT directors, and data warehousing users.