QxData Database Solution for Microsoft SQL

QxData Database solution for Microsoft SQL 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.

The QxData Database Solution for Microsoft SQL is validated running SQL Server 2016 and configured by the high performance system Quanta Grid D51B-2U server with enterprise grade flash storage built for SQL data warehouse demand.

QxData Database Solution for Microsoft SQL Server 2016  (DWFT – 50TB)

The Quanta STRATOS S400-X44E is a high density 4-socket rackmount server, supporting up to four 8-core Intel® Xeon® processor E5-4600 family and 48 DIMM slots. It increases up to 75% computing performance and 2 times of memory & I/O performance compared with Intel® Xeon® E5-2600 2-socket servers. It also offers a significant boost in FLOPs, plus its large memory of up to 48 DIMM slots, making the system ideal for HPC, mission-critical and any computing power/memory constrained applications such as ERP, CRM, memcached, data analysis, and virtualization.

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


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:


Detailed Product Specification: QxData Database Solution for Microsoft SQL Server 2016 (DWFT - 50TB)


Server System: QuantaGrid D51B-2U


Intel® Xeon® E5-2695 v4 (2.1Ghz, 18 cores)

Total sockets


Total Physical Cores


Total RAM

768GB (24 * 32GB RDIMM)

RAM Type


Internal (OS) Storage

2 * 480GB SATA SSD (Raid 1)

Host bus adapters

LSI 3108-8i R6 Mezz Card (12Gbps)

Network adapters

Mellanox ConnectX-3 Pro (Dual-Port, SFP+, 10GbE)


Storage Array


Disk Drives

24 * 1.6TB SATA SSDs for SQL database storage

Storage Information

Option 1:
24 * 1.6TB SATA SSD for Data, TempDB and Log (Raid 10)

Option 2:
4 * 1.6TB SATA SSD for Log (Raid 10); 20 * 1.6TB SATA SSD for Data and TempDB (Raid 5)


SQL Server Edition

SQL Server 2016 Enterprise Edition

Operating System

Windows Server 2016

あなたのリクエストを完了できません。 !

トピックの詳細は (FAQページ) を参照するか、(お問い合わせ)について弊社までご連絡ください

伊藤忠テクノソリューションズ株式会社 - Reseller / System Integrator

100-6080 東京都千代田区霞が関3-2-5


TEL 03-6203-5000

Quanta Cloud Technology Japan 株式会社 - QCT Solutions

東京都港区芝大門2-5-8 芝大門牧田ビル3F, 105-0012

TEL 03-5777-0818