WD White Paper - SQL Server 2017 DWFT
Summary
Optimize your enterprise Business Intelligence infrastructure with this definitive reference architecture guide. This document details high-performance configurations for Microsoft SQL Server Data Warehouse using HPE ProLiant DL580 Gen10 servers and massive Ultrastar SSD storage. It provides expert guidance on optimizing hardware sizing, utilizing consumption-based techniques to maximize ROI while ensuring peak IOPS performance. Essential reading for BI Architects, DBAs, Cloud Providers, and IT Directors designing mission-critical data warehouse solutions.
Page 1 Text Content
WHITE PAPER HPE Pro Liant DL580 Gen10 and Ultrastar® SS300 SSD 195TB Microsoft® SQL Server® Data Warehouse Fast Track Reference Architecture BASED ON MICROSOFT SQL SERVER 2017 DATA WAREHOUSE FAST TRACK REFERENCE ARCHITECTURE
Page Summary Contents For WD White Paper - SQL Server 2017 DWFT
Manual Details
| Brand | Server |
|---|---|
| Pages | 11 |
| File Size | 4.13 MB |
| Published | June 02, 2026 |
Enter the captcha to get the download link:
Frequently Asked Questions
How does the Data Warehouse Fast Track (DWFT) approach help with hardware planning?
The DWFT reference architecture is designed to eliminate complexity in sizing hardware by using a consumption-based approach for I/O and CPU, ensuring efficient use of your investment.
What are the two primary read block sizes used by SQL Server during testing?
SQL Server primarily reads data in 8KB (the size of a data page) and 64KB (the size of an extent).
Why is using Ultrastar SSDs recommended for this architecture?
The system uses HPE ProLiant DL580 Gen10 combined with Ultrastar SS300 SSDs to boost IOPS performance, enabling fast-track data warehousing.