Deploying Analytics to Increase Business Value

The volume of data business is generating today requires massive storage, processing, and strategic analytics in order to derive the greatest value back to the organization. The need is so great that the global database management systems market is expected to reach a market size of $63 billion by 2022.1

In order to facilitate faster and easier deployment of these systems, Intel has created a portfolio Intel® Select Solutions for Analytics with leading software vendors. With the release of 2nd Generation Intel® Xeon® Scalable processors and public availability of Intel® Optane™ DC persistent memory, Intel is updating and introducing new solution reference designs to take full advantage of the new products, technology features and software releases. Current existing Intel Select Solutions can be upgraded with equivalent 2nd Generation Intel Xeon Scalable processors offering higher performance and enhanced security capabilities.

Microsoft SQL Server*

Enterprise data center IT managers need database-as-a-service (DBaaS) solutions that can meet the escalating demands of online transaction processing (OLTP), hybrid transactional/analytical processing (HTAP), and advanced analytics. Many organizations utilize Microsoft SQL Server* as part of their DBaaS deployment because of the high performance, robust security, and flexibility in programming languages it provides. In addition, Microsoft SQL Server offers in-database advanced analytics using SQL Server Machine Learning Services.

Under ordinary database workloads, the traditional way to scale up Microsoft SQL Server is to add DRAM. But for workloads like machine learning (ML), predictive analytics, and HTAP, that practice has limitations. Those workloads require infrastructure that can smoothly handle sharp spikes and drops in transaction volume and can accommodate both business operations and enterprise data warehouse (EDW) operations. Intel® Select Solutions for Microsoft SQL Server on Windows Server* v2 takes advantage of 2nd Generation Intel Xeon Scalable processors and the new Intel Optane DC persistent memory’s high-capacity, lower-cost benefits to scaling out a DBaaS hosting environment and are designed to handle the workloads of business users running OLTP, EDW, or both.

Intel Select Solutions for Microsoft SQL Server on Windows Server v2 provides building blocks for a multi-tenant scale out SQL server hosting environment for concurrent workloads e.g. operational and analytical workloads. These next generation Intel Select Solution configuration when coupled with Microsoft Windows Server 2019 and Microsoft SQL Server 2017, boost transaction processing 21% and reduces data warehouse query time by 11%.2 Premium configurations featuring Intel Optane SSD and Intel Optane DC persistent memory further reduce data warehouse query time by 31%.3 The new solutions will soon be available from original equipment manufacturers (OEMs) like DataOn, Fujitsu, and Lenovo. Additionally, Intel® Select Solutions for Microsoft SQL Linux v2 will be available later this year.

SAP HANA*

The SAP HANA* platform is a flexible, data source agnostic, in-memory data platform that provides real-time data analysis of large data volumes. SAP and Intel have co-innovated on the SAP HANA platform since its inception and continue to work together to offer one of the most efficient and highest performing analytics platforms available today.

Intel® Select Solutions for SAP HANA* leverages that work and focus on the SAP HANA Tailored Datacenter Integration (TDI) implementation. SAP HANA TDI gives customers flexibility to use a variety of hardware and infrastructure components, however it can be challenging to determine what might work best. The Intel Select Solutions for SAP HANA helps take some of the guesswork out of all the SAP HANA TDI possibilities, while still offering a variety of memory ratio options utilizing both DRAM and Intel Optane DC persistent memory.  SAP and Intel’s testing and optimization of this solution have demonstrated that companies can benefit from increased business continuity available from reduced database restart time from 20 minutes to 90 sec (a 13x improvement) when using Intel Optane DC persistent memory vs a DRAM only memory subsystem.4

Customers wanting to update existing SAP solutions, or those that want a turn-key SAP HANA solution that enables them to perform business processing and analytics in real time, will soon be able to deploy this new solution from an emerging and growing set of OEM solution partners. Intel Select Solutions for SAP HANA will be available this year from a number of OEMs including Lenovo and Supermicro.

Intel Xeon Scalable Processors

The new Intel Select Solutions feature the Intel Xeon Scalable processor platform, Intel Optane DC persistent memory, Intel® Solid State Drive (SSD) technology, Intel® Ethernet Connections, and Intel® Ethernet Converged Network Adapters. Proven to scale, these pre-tuned and tested configurations are workload-optimized and allow organizations to deploy data center infrastructure quickly and efficiently with less tuning. For more information, visit intel.com/selectsolutions. For more information on how to accelerate your data insights and building your infrastructure, visit intel.com/yourdata.


1 https://www.marketresearchfuture.com/reports/database-management-system-market-1972

2 SQL v1 – Business Operations (OLTP) Baseline configuration 1 Node, 2x Intel® Xeon® Gold 6132 CPU, Intel® Server Board S2600WFT, Total Memory 192 GB, 12 slots/16 GB/2666 MT/s DDR4 RDIMM, HyperThreading: Enable, Turbo: Enable, Storage(boot): 1X 480 GB Intel® SSD S3520 Series M.2 SATA 2.5, Storage(Data Drive):4x 3.8TB Intel® SSD DC S4500 with RAID[0], Storage(Log Drive):4x 1.6TB Intel® SSD DC P4610 PCIe NVME with RAID[0];Network devices: 1x Intel® Ethernet Converged Network Adapter X540-T2, Network speed: 10GbE, ucode:0x2000043, OS/Software: Windows server 2016 Data center edition with SQL Server 2016 SP2 CU3 Enterprise Edition

SQL v1 – Enterprise Data Warehouse (HTAP) Intel internal testing as of July 12, 2018. Baseline configuration 1 Node, 2x Intel® Xeon® Gold 6132 CPU, Intel® Server Board S2600WFT, Total Memory 384 GB, 24 slots/16 GB/2666 MT/s DDR4 RDIMM, Intel® Hyper Threading Technology: Enable, Turbo: Enable, Storage (boot): 1X 240 GB Intel® SSD 540s Series M.2 SATA 3.0, Storage (Data Drive):4x 2 TB Intel SSD DC P4500X PCIe* NVMe, Storage (Log Drive):2x 1.6 TB Intel SSD DC P4600X PCIe NVME;2x 480 GB Intel SSD DC S4600 SATA, Network devices: 1x Intel® Ethernet Converged Network Adapter X710 dual port, Network speed: 10 GbE, ucode:0x2000043, OS/Software: Windows server 2016 Data center edition with SQL Server 2017 Enterprise Edition

SQL v2 – Combined Configs for both Business Operations (OLTP) and Enterprise Data Warehouse (HTAP)

This Solution was tested between 14-Feb-2019 to 11-Mar-2019 with the following hardware and software configuration: Configuration: 1 Node, 2x Intel® Xeon® Gold 5218 CPU; 1x Intel® Server Board S2600WFT; Total Memory: 384GB (12 x 32GB 2933MHz 288-pin DDR4 RDIMM); HyperThreading: Enable; Turbo: Enable; Storage(boot): 1 x Intel® SSD D3-S4510 Series (>=240GB, 2.5in SATA 6Gb/s, 3D2, TLC); Storage (Data Drive): 6 x Intel SSD DC P4510 Series (2TB) (NVMe); Storage (Log Drive): 2 x Intel SSD DC P4610 Series (1.6TB) (NVMe)[RAID 1]; Network devices: 1x Intel® Ethernet Converged Network Adapter X722-T2

Network speed: 10 GbE; OS/Software: Windows server 2016 Datacenter Edition build 14393 with SQL Server 2017 Enterprise Edition RTM CU13

3 > Compare SQL v2 – Combined Configs for both Business Operations (OLTP) and Enterprise Data Warehouse (HTAP). This Solution was tested between 14-Feb-2019 to 11-Mar-2019 with the following hardware and software configuration:

Base Configuration: 1 Node, 2x Intel® Xeon® Gold 5218 CPU; 1x Intel® Server Board S2600WFT; Total Memory: 384GB (12 x 32GB 2933MHz 288-pin DDR4 RDIMM); HyperThreading: Enable; Turbo: Enable; Storage(boot): 1 x Intel® SSD D3-S4510 Series (>=240GB, 2.5in SATA 6Gb/s, 3D2, TLC); Storage (Data Drive): 6 x Intel SSD DC P4510 Series (2TB) (NVMe); Storage (Log Drive): 2 x Intel SSD DC P4610 Series (1.6TB) (NVMe)[RAID 1]; Network devices: 1x Intel® Ethernet Converged Network Adapter X722-T2

Network speed: 10 GbE; OS/Software: Windows server 2016 Datacenter Edition build 14393 with SQL Server 2017 Enterprise Edition RTM CU13

Plus configuration: 1 Node, 2x Intel® Xeon® Gold 6248 CPU; 1x Intel® Server Board S2600WFT;  Total Memory: 768 GB DRAM (24x 32 GB 2933MHz 288-pin DDR4 RDIMM), 384GB (12 x 16GB 2933MHz 288-pin DDR4 RDIMM) + 1024 GB Intel Optane DC Persistent Memory (8 x 128GB, 288-pin Intel Persistent Memory DIMM); HyperThreading: Enable; Turbo: Enable; Storage(boot): 2 x Intel® SSD D3-S4510 Series (240GB, 2.5in SATA 6Gb/s, 3D2, TLC) (Mirrored); Storage (Data Drive): 6x Intel SSD DC P4510 Series (4TB) (NVMe); Storage (Log Drive): 2 x Intel SSD DC P4800X 750GB (NVMe) [RAID 1]; Network devices: 1x Intel® Ethernet Converged Network Adapter X722-T2

Network speed: 10 GbE; OS/Software: Windows server 2019 Datacenter Edition build 17763 with SQL Server 2017 Enterprise Edition RTM CU13

4 (SAP HANA Faster Restart: Baseline Configuration (DRAM ONLY): Testing was conducted by Intel in March 2019, with the following hardware and software configurations: 1 Node, 4x Intel® Xeon® Platinum 8280M, 1x Intel® Lightning Ridge System, Memory: 6TB (48x 128GB) DDR4 RDIMM at 2666 MT/s; Storage: 60x 480GB Intel® SSD DC S4600 SATA; Network devices: 10GbE Intel X520; ucode: 0x04000010; OS/Software: Suse 15; SAP HANA database size: 3TB

Advanced Configuration (with Intel Optane DC persistent memory): Testing was conducted by Intel in March 2019, with the following hardware and software configurations: 1 Node, 4x Intel® Xeon® Platinum 8280L, 1x Intel® Lightning Ridge System, Memory: 9TB (24x 128GB DDR4 RDIMM at 2666 MT/s and 24x 256GB Intel® Optane™ DC persistent memory) ; Storage: 90x 480GB Intel® SSD DC S4600 SATA; Network devices: 10GbE Intel X520; ucode: 0x04000010; OS/Software: Suse 15; SAP HANA database size: 6TB