QxData DWFT Certified Microsoft SQL Solution
Validated Microsoft DWFT (Data Warehouse Fast Track) Solution
QxData DWFT Certified Microsoft SQL Solution completed with Microsoft Data Warehouse Fast Track (DWFT) benchmark, can ensure the customer pre-tuned, fast query database performance that is optimized running intensive query workloads and validated by Microsoft. This solution can solve large database challenges with a good price-to-performance ratio, reduced maintenance and ensured high performance to address business analytics on growing data volumes.
Solution to large database challenges
Today’s ever-changing business world relies more than ever on the generation, collection, and analysis of data. While enterprises had a limited time window to load large quantities of data and were routinely querying large data volumes that often required full table scans and multi-pass queries, the performance of the data warehouse to reduce query execution times became the most critical topic for IT.
QxData Database Solution for Microsoft SQL Server 2016 (DWFT – 50TB)
QuantaGridD51B-2U is Full-Featured Design for Demanding Storage and Computing Workload. It supports up to 1.5 TB highly scalable memory capacity and twenty-four 2.5” hot-swappable HDD for complex and demanding workloads, such as mail-server, database, e-commerce and high-performance computing (HPC). Validated by Microsoft Data Warehouse Fast Track (DWFT) benchmark, this DWFT -50TB configuration can deliver solid database performance metrics as following:
Validated by Microsoft Data Warehouse Fast Track (DWFT) benchmark, this DWFT -50TB configuration can deliver solid database performance metrics as following:
- Rated User Data Capacity: 50TB
- Row Store Rated I/O: 5,649 Mbps
- Column Store Throughput: 1,637 Queries / Hr / TB
QxData Database Solution for Microsoft SQL Server 2017 (DWFT – 39TB)
QuantaGridD52BQ-2U is with Ultimate Compute and Storage Density designed for optimal performance and power efficiency. It supports up to 3TB highly scalable memory capacity and twenty-four 2.5” hot-swappable HDD for complex and demanding workloads, such as mail-server, database, e-commerce and high-performance computing (HPC).
- Rated User Data Capacity: 39TB
- Row Store Rated I/O: 7,240 Mbps
- Column Store Throughput: 2,261 Queries / Hr / TB
QCT continues to bring innovation to market with its Intel® Select Solution for Microsoft SQL Server, this solution will help IT to accelerate deployment of hybrid database platforms addressing the challenges of increased workload complexity and long implementation cycles in developing scalable.
This collaboration between Intel and QCT addresses the continuing needs of our mutual customers by delivering a cloud-ready solution geared towards businesses with large analytic challenges. We are thrilled to continue our investment in game-changing technologies with this software-defined solution, with QCT’s QxData SQL offering, we are proud to be at the front line in leading data center transformation together with Intel to meet the needs of our ever-evolving customer demands.
Pre-tuned, fast query performance
Pre-tuned, fast query performance that is optimized running intensive query workloads and validated by Microsoft Data Warehouse Fast Track (DWFT) program.
Balanced mix of hardware and software
Selecting and pre-configuring the right mix of hardware, software, tools, settings, and optimizations included in the reference architecture to best address SQL Server workloads.
Fast deployment
Ease of deployment and product selection to the customer with written reference architecture.
Microsoft Data Warehouse Fast Track (DWFT) Program
Microsoft Data Warehouse Fast Track is a joint effort between Microsoft and its hardware partners, QCT for instance, to deliver validated, pre-configured solutions that reduce the complexity and risk of implementing an SMP data warehouse based on SQL Server Enterprise Edition. The Fast Track program provides flexibility of solutions and customer choice across hardware vendors’ technologies, and uses the core capabilities of the Windows Server operating system and SQL Server to deliver a balanced SMP data warehouse with optimized performance.
For more information of Microsoft DWFT Program:
QxData DWFT Certified Microsoft SQL Solution Specification
QxData DWFT Certified Microsoft SQL Solution Specification | |||
---|---|---|---|
DWFT - 50TB | DWFT - 39TB | ||
Server | System | QuantaGrid D51B-2U | QuantaGrid D52BQ-2U |
Processors | Intel® Xeon® E5-2695 v4 (2.1Ghz, 18 cores) | Intel® Xeon® Gold 6138 CPU @ 2.00 GHz 20C/40T | |
Total sockets | 2 | 2 | |
Total Physical Cores | 36 | 40 | |
Total RAM | 768GB (24 x 32GB RDIMM) | 768GB (24 x 32GB RDIMM) | |
RAM Type | DDR4 2133MHz | DDR4 2666MHz | |
Internal (OS) Storage | 2 x 480GB SATA SSD (RAID 1) | 2 x 480GB SSD (RAID 1) | |
Host bus adapters | LSI 3108-8i R6 Mezz Card (12Gbps) | Avago MegaRAID SAS 9361-16i | |
Network adapters | Mellanox ConnectX-3 Pro (Dual-Port, SFP+, 10GbE) | Mellanox 25GbE ConnectX-4 Lx EN Dual Port | |
Storage | Storage Array | In-Server | In-Server |
Storage Information | 24 x 1.6TB SATA SSDs for SQL Database Storage | 8 x 1.6 TB SSD for Data and TempDB (RAID 0) | |
Option 1: 24 x 1.6TB SATA SSD for Data, TempDB and Log (Raid 10) Option 2: 4 x 1.6TB SATA SSD for Log (Raid 10); 20 x 1.6TB SATA SSD for Data and TempDB (Raid 5) | 2 x 480 GB SSD for OS (RAID 1) 4 x 1.92 TB SSD for log (RAID 0) 6 x 2 TB HDD for backup (RAID 0) | ||
Software | SQL Server Edition | SQL Server 2016 Enterprise Edition | SQL Server 2017 Enterprise Edition |
Operating System | Windows Server 2016 | Windows Server 2016 |
Downloads for QxData DWFT Certified Microsoft SQL Solution
Reference Architecture
QxData DWFT Certified Microsoft SQL 2016 Solution
(EN)
QxData DWFT Certified Microsoft SQL 2017 Solution
(EN)
Contact QCT Expert
Get more information about QCT Solutions!