WD Western Data SQL Server 2017 DWFT HP DL580 Gen10 195TB Reference Architecture Internal Solid State Drive Internal Solid State Drive White Paper English (US)
Summary
Optimize your data warehouse infrastructure with this reference architecture built upon HPE ProLiant DL580 Gen10 servers and high-speed Ultrastar SS300 SSDs. This guide walks IT professionals, BI Architects, DBAs, and Cloud Providers through designing enterprise Business Intelligence solutions using Microsoft SQL Server 2017. The manual details optimal resource sizing based on actual I/O and CPU consumption, ensuring your data warehouse maximizes its hardware investment while eliminating scaling complexity.
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 Western Data SQL Server 2017 DWFT HP DL580 Gen10 195TB Reference Architecture Internal Solid State Drive Internal Solid State Drive White Paper English (US)
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 architecture help system design?
It is designed to eliminate complexity in adequately sizing hardware, correctly based on I/O and CPU consumption.
What operating systems pair with this reference architecture?
The setup specifies compatibility with Windows Server 2016 for the OS configuration.
What are the most frequently read data block sizes according to testing?
8KB (data page size) and 64KB (extent size) account for 78% of SQL Server's total read I/O.
Beyond the main database, what storage configurations must be detailed?
The reference architecture requires configuring physical storage layout, standalone storage spaces, and specific settings for Tempdb.