Intel Select Solutions for Microsoft SQL Server

Today, the world of data is changing faster than ever. To keep up, you need a data platform that challenges the status quo and makes it possible to ingest, manage, store, and analyze any type of data from anywhere. Microsoft SQL Server 2019 running on Intel Xeon Scalable processors provides this modern data platform.

View the Microsoft SQL Server on Windows v2 solution brief ›

View the Microsoft SQL Server on Linux solution brief ›

View the Microsoft SQL Server on Windows v3 solution spotlight ›

Base and Plus Configurations for Intel Select Solutions for SQL Server on Windows Server v2

Ingredient
Intel Select Solutions for Microsoft SQL Server on Windows Server v2 Base Configuration
Intel Select Solutions for Microsoft SQL Server on Windows Server v2 Plus Configuration
Platform
Intel® Server Board S2600WFT Qual
Intel Server Board S2600WFT Qual
Processor
2 x Intel® Xeon® Gold 5218 processor at 2.30 GHz (16 cores, 32 threads), or a higher number Intel Xeon Scalable processor
2 x Intel® Xeon® Gold 6248 processor at 2.60 GHz (20 cores, 40 threads), or a higher number Intel Xeon Scalable processor
Memory
384 GB or higher (12 x 32 GB 2,933 MHz 288-pin DDR4 RDIMM)
384 GB (12 x 32 GB 2,933 MHz 288-pin DDR4 RDIMM) and 1.0 TB Intel Optane™ DC persistent memory (8 x 128 GB) or 768 GB (24 x 32 GB 2,933 MHz 288-pin DDR4 RDIMM)
Persistent-Memory-to-DRAM Ratio
N/A
2.67:1 (or lower) (1,024 GB:384 GB)
Boot Drive**
1 x 240 GB Intel® Solid State Drive D3-S4510 (2.5-in. SATA 6 gigabits per second [Gb/s], 3D2, TLC) or more
2 x 240 GB Intel SSD D3-S4510 Series (2.5-in. SATA 6 Gb/s, 3D2, TLC) or more (mirrored)
Log Drive
2 x 1.6 TB Intel® SSD DC P4610 Series (NVM Express [NVMe])
2 x 750 GB Intel® Optane™ SSD DC P4800X (NVMe)
Data Drive
6 x 2 TB Intel SSD DC P4510 (NVMe)
6 x 4 TB Intel SSD DC P4510 (NVMe)
Data Network
10Gb Intel® C620 series chipset with integrated Intel® Ethernet Network Connection X722
10Gb Intel C620 series chipset with integrated Intel Ethernet Network Connection X722
Management Network
Integrated 1 gigabit Ethernet (GbE)
Integrated 1 GbE
Software
Windows Server 2016 Standard edition or higher SQL Server 2017 or higher
Windows Server 2019 Standard edition or higher SQL Server 2017 or higher
TPM
TPM 2.0 discrete or firmware TPM (Intel® Platform Trust Technology (Intel® PTT))
TPM 2.0 discrete or firmware TPM (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 SATA**

NVMe drivers**

C-states disabled

Operating system power management plan set for performance

Intel HT Technology enabled

Intel Turbo Boost Technology enabled

Intel Speed Shift Technology, HWP native

Intel RSTe for SATA**

C-states disabled

Operating system power management plan set for performance

Minimum Performance Standards
Verified to meet or exceed the following minimum performance capabilities: **Recommended, not required

Base and Plus configurations for Select Solutions for Microsoft SQL Server on Linux, Optimized for HTAP

Ingredient

Intel Select Solutions for Microsoft SQL Server on Linux Base Configuration

Intel Select Solutions for Microsoft SQL Server on Linux Plus Configuration

Processor

2 x Intel® Xeon® Gold 5218 processor at 2.30 GHz, 16 cores, 32 threads, or a higher number 2nd Generation Intel Xeon Scalable processor

2 x Intel® Xeon® Gold 6248 processor at 2.60 GHz, 20 cores, 40 threads, or a higher number 2nd Generation Intel Xeon Scalable processor

Memory

384 GB (12 x 32 GB 2,933 MHz 288-pin DDR4 RDIMM)

1,024 GB 2LM/memory mode (8 x 128 GB, 288-pin Intel® Optane™ DC persistent memory + 384 GB (12 x 32 GB 2,933 MHz 288-pin DDR4 RDIMM) or 768 GB DRAM (24 x 32 GB 2,933 MHz 288-pin DDR4 RDIMM)

Boot Drive

1 x Intel® SSD D3-S4510 (greater than or equal to 240 GB, 2.5 in Serial ATA [SATA] 6 gigabits per second [Gbps], 3D2, triple-level cell [TLC])*

2 x Intel SSD D3-S4510 (greater than or equal to 240 GB, 2.5 in SATA 6 Gbps, 3D2, TLC) (mirrored)*

Log Drive

2 x 1.6 TB Intel SSD DC P4610, NVM Express (NVMe)

2 x 750 GB Intel Optane SSD DC P4800X, NVMe

Data Drive

6 x 2 TB Intel SSD DC P4510, NVMe

6 x 4 TB Intel SSD DC P4510, NVMe

Data Network

10Gb Intel® C620 series chipset with integrated Intel Ethernet Network Connection X722 and Intel® Ethernet Network Connection OCP X527-DA2

or

10Gb dual-port Intel Ethernet Converged Network Adapter X710*

10Gb Intel C620 series chipset with integrated Intel Ethernet Network Connection X722 and Intel Ethernet Network Connection OCP X527-DA2 or 25Gb dual-port Intel Ethernet Converged Network Adapter XXV710 or 40Gb dual-port Intel Ethernet Converged Network Adapter XL710*

Management Network

Integrated 1 gigabit Ethernet (GbE)

Integrated 1 GbE

Software

Red Hat Enterprise Linux 7.6 or later

SQL Server 2017 Enterprise Edition, version 14.0.3192.2 or later

Red Hat Enterprise Linux 7.6 or later

SQL Server 2017 Enterprise Edition, version 14.0.3192.2 or later

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

CPU C-state control > package C-state: C0/C1 state

CPU C-state control > processor C6 disabled

Operating system power-management plan set for performance

LLC prefetcher enabled

MLC spatial prefetcher enabled

CPU power and performance policy set to performance

Workload configuration balanced

Uncore frequency scaling disabled

Performance P-limit disabled

Intel HT Technology enabled

Intel Turbo Boost Technology enabled

Intel Speed Shift technology, HWP native

CPU C-state control > package C-state: C0/C1 state

CPU C-state control > processor C6 disabled

Operating system power-management plan set for performance

LLC prefetcher enabled

MLC spatial prefetcher enabled

CPU power and performance policy set to performance

Workload configuration balanced

Uncore frequency scaling disabled

Performance P-limit disabled

*Recommended, not required