Aligned with the building-block approach to scaling out a database-as-a-service hosting environment and designed to handle the concurrent, variable workloads of business users running OLTP, EDW, or both. Built on 2nd Gen Intel® Xeon® Scalable processors.
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 | ||