Intel® Select Solutions for SQL Server* Enterprise Data Warehouse

Extract powerful insights from big data using validated data warehouse solutions.

View the product brief ›

The Base and Plus Configurations for Intel® Select Solutions for Microsoft* SQL Server Enterprise Data Warehouse (Run on Windows Server*), Optimized for HTAP

Component Intel® Select Solutions for Microsoft* SQL Server Enterprise Data Warehouse (Run on Windows Server*) Base Configuration for Databases up to 25TB Intel® Select Solutions for Microsoft* SQL Server Enterprise Data Warehouse (Run on Windows Server*) Plus Configuration for Databases up to 70 TB

Processor

2 x Intel® Xeon® Gold 6132 processor (2.60 GHz, 14 cores/28 threads), Intel® Xeon® Gold 6230 processor (2.1 GHz. 20 cores), or a higher number Intel® Xeon® Scalable processor

2 x Intel® Xeon® Gold 6150 processor (2.70 GHz, 18 cores/36 threads), Intel® Xeon® Gold 6248 processor (2.5 GHz, 20 cores), or a higher number Intel® Xeon® Scalable processor

Memory

384 GB (24 x 16 GB 2,666 MHz DDR4 RDIMM)

768 GB (24 x 32 GB 2,666 MHz DDR4 RDIMM)

Boot Drive

1 x Intel® Solid State Drive DC S3520 Series, greater than or equal to 240 GB M.2 or 2.5-inch1

1 x Intel® SSD DC S3520 Series, greater than or equal to 240 GB M.2 or 2.5-inch1

Log Drive

2 x Intel® SSD DC P4600/P4610 Series, 1.6 TB, NVM Express* (NVMe*)

or

2 x Intel® SSD DC S4600/S4610 Series, SATA

2 x Intel® Optane™ SSD DC P4800X Series, 375 GB, NVMe*

Data Drive

4 x Intel® SSD DC P4500/P4510 Series, 2 TB, NVMe*

6 x Intel® SSD DC P4500/P4510 Series, 4 TB, NVMe*

Data Network

10 Gb Intel® Ethernet Connection X722 with Intel® Ethernet Connection OCP X527-DA2/DA4

or

10 Gb Intel® Ethernet Converged Network Adapter X710-DA2/DA4

or

40 Gb Intel® Ethernet Converged Network Adapter (Intel® Ethernet CNA) XL710-QDA2

10 Gb Intel® Ethernet Connection X722 with Intel® Ethernet Connection OCP X527-DA2/DA4

or

10 Gb Intel® Ethernet Converged Network Adapter X710-DA2/DA4

or

40 Gb Intel® Ethernet Converged Network Adapter (Intel® Ethernet CNA) XL710-QDA2

Management Network

Integrated 1 gigabit Ethernet (GbE)

Integrated 1 GbE

Software

Windows Server* 2016 Standard edition or higher

SQL Server* 2017
(.NET Framework 4.5* installed as part of SQL Server 2017)

Windows Server* 2016 Standard edition or higher

SQL Server* 2017
(.NET Framework 4.5 installed as part of SQL Server 2017)

Trusted Platform  Module (TPM)

TPM 2.0 or Intel® Platform Trust Technology (Intel® PTT)

TPM 2.0 or Intel® PTT

Firmware and Software Optimizations

Intel® Hyper-Threading Technology (Intel® HT Technology) enabled

Intel® Turbo Boost Technology enabled

Intel® Speed Shift technology, Hardware P-states (HWP) native

Intel® Rapid Storage Technology enterprise (Intel® RSTe) for SATA1

Intel NVMe* drivers1

C-states disabled

Operating system power management and plan set for performance

Intel® HT Technology enabled

Intel® Turbo Boost Technology enabled

Intel® Speed Shift Technology, HWP native

Intel® RSTe for SATA1

Intel NVMe* drivers

C-states disabled

Operating system power management and plan set for performance

Minimum Performance standards

Verified to meet or exceed the results below as measured by the Microsoft Data Warehouse Fast Track* for SQL Server* program:

  • 25 TB user data capacity
  • 220 rowstore measured throughput (queries/hour/TB)
  • 2,670 columnstore measured throughput (queries/hour/TB)

Verified to meet or exceed the results below as measured by the Data Warehouse Fast Track* for SQL Server* program:

  • 70 TB user data capacity
  • 320 rowstore measured throughput (queries/hour/TB)
  • 3,440 columnstore measured throughput (queries/hour/TB)
Business Value of Choosing a Plus Configuration Instead of a Base Configuration Up to 45% faster query performance per TB with 2.8x more data warehouse capacity per two-socket server2

Informasi Produk dan Performa

1Recommended not required.
2

Pengujian internal Intel per 07 Juli 2018. Konfigurasi Dasar: Satu node, 2 x prosesor Intel® Xeon® Gold 6132, Intel® Server Board S2600WFT, memori total: 384 GB, DDR4 RDIMM 24 slot/16 GB/2.666 megatransfer per detik (MT/s), Intel® Hyper-Threading Technology (Intel® HT Technology) diaktifkan, Intel® Turbo Boost Technology diaktifkan; penyimpanan (boot): Intel® SSD Seri 540s M.2 SATA III 240 GB, penyimpanan (drive data): 4 x Intel® SSD DC Seri P4500 2 TB Peripheral Component Interconnect Express* (PCIe*) dengan NVM Express* (NVMe*), penyimpanan (drive log): 2 x Intel® SSD DC Seri P4600 1,6 TB PCIe* dengan NVMe*, 2 x Intel® SSD DC Seri S4600 Serial ATA (SATA) 480 GB; perangkat jaringan: 1 x Intel® Ethernet Converged Network Adapter X710 (Intel® Ethernet CNA X710) dual-port 10 Gb, kecepatan jaringan: 10 GbE, ucode: 0x043, OS/perangkat lunak: Windows Server* 2016 edisi Data Center dengan SQL Server* 2017 edisi Enterprise. Konfigurasi Plus: Satu node, 2 x prosesor Intel® Xeon® Gold 6150, Intel® Server Board S2600WFT, memori total: 768 GB, DDR4 RDIMM 24 slot/32 GB/2.666 MT/s , Intel® HT Technology diaktifkan, Intel® Turbo Boost Technology diaktifkan; penyimpanan (boot): Intel® SSD Seri 540s M.2 SATA III 240 GB, penyimpanan (drive data): 6 x Intel® SSD DC Seri P4500 4 TB PCIe* dengan NVMe*, penyimpanan (drive log): 2 x Intel® Optane™ SSD DC Seri P4800X 375 GB PCIe* dengan NVMe*; perangkat jaringan: 1 x Intel® Ethernet Converged Network Adapter X710 dual-port 10 Gb, kecepatan jaringan: 10 GbE, ucode: 0x043, OS/perangkat lunakWindows Server* 2016 edisi Data Center dengan SQL Server* 2017 edisi Enterprise.