Microsoft® SQL Server Data Warehouse
Supermicro® Microsoft® Certified Solutions
Supermicro and Microsoft have partnered together to deliver industry leading
"fully certified solutions". These solutions are delivered on highly optimized and
flexible Supermicro Server and Storage Systems. Supermicro Systems are designed
to provide significant advantage to these solutions in the areas of power efficiency,
performance and overall system optimization. These design principles coupled
with bringing innovative technologies at an accelerated pace drives time to market
value for Microsoft Solutions. In case of some of these disruptive technologies like
NVMe, Supermicro is an established leader with the broadest range of products that
customers can choose from.
Microsoft Certified Solutions running on Supermicro hardware consist of Windows Server,
SQL Server Data Warehouse, Exchange Server, Hyper-converged solutions like Storage
Spaces Direct, Storage Server and Azure Stack. These solutions are optimized for
Enterprise, Hybrid Cloud, Private and Public Cloud markets. We also deliver the Windows
operating system software preloaded for fast growing SMB and Enterprise customers.
Supermicro has consistently innovated in the areas of designing Server board, Chassis,
highly efficient power supply, network interconnect and storage systems. The building
block approach is one of the key innovations to Server system architecture. This vertically
integrated design approach accelerates the delivery of application optimized Microsoft
Solutions based on customer requirements.
Data Warehouse Fast Track For Microsoft® SQL Server®
Microsoft Data Warehouse Fast Track (DWFT) for SQL Server® 2016 is designed to
provide customers optimized and validated system architectures for addressing data
warehouse workload challenges including exponential growth of data, demands of lower
data latency and faster query response times.
Supermicro has partnered with Microsoft to deliver Industry's highest performance 70TB
SQL Server 2016 DWFT reference architecture in 2 socket systems, leveraging highly
efficient Ultra Servers utilizing low latency and high throughput NVMe SSD's.
| 70TB DWFT | 40TB DWFT | 22TB DWFT | |
|---|---|---|---|
| Model |
 SMCI DP |
SMCI DP |
 SMCI DP |
| CPU | Intel Xeon E5-2690 v4 2.60GHz 135W 14 core x2 | Intel Xeon E5-2690 v4 2.60GHz 135W 14 core x2 | Intel Xeon E5-2690 v4 2.60GHz 135W 14 core x2 |
| Memory | 32GB DDR4-2133 x24 = 768GB | 32GB DDR4-2133 x24 = 768GB | 32GB DDR4-2133 x24 = 768GB |
| Data storage | 2.5" NVMe 3.2TB x 10 = 32TB |
2.5" NVMe P3700 800GB x8 2.5" NVMe P3600 2TB x 4 = 14.4TB |
2.5" NVMe P3600 2TB x 4 = 8TB |
| Log | 2TB SAS3 SSD 2.5" x4 (Raid 10) |
2TB SAS3 SSD 2.5" x4 (Raid 10) |
300GB 12G SAS3 HD 15k 2.5" x8 (Raid 10) |
| OS | 400GB SATA3 SSD x2 (Raid 1) | 480GB SATA3 SSD x2 (Raid 1) | 480GB SATA3 SSD x2 (Raid 1) |
| Storage AOC | S3108L-H8iR (HW raid) | S3108L-H8iR (HW raid) | S3108L-H8iR (HW raid) |
| Performance | |||
| Rated User Data Capacity (TB) | 70 | 40 | 22 |
| Row Store relative Throughput | 225 | 210 | 166 |
| Column Store relative Throughput | 339 | 213 | 196 |
| Maximum User Data Capacity (TB) | 103 | 48 | 25 |
| Row Store | |||
| Relative Throughput | 225 | 210 | 166 |
| Measured Throughput (Queries/Hr/TB) | 274 | 244 | 202 |
| Measured Scan Rate Physical (MB/Sec) | 5820 | 5571 | 4348 |
| Measured Scan Rate Logical (MB/Sec) | 7409 | 6790 | 5436 |
| Measured I/O Throughput (MB/Sec) | 6614 | 6180 | 4892 |
