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 | ||