Intel® Select Solutions for Microsoft SQL Server* on Windows Server

Intel® Select Solutions for Microsoft SQL Server* on Windows Server

This application will scale out multi-tenant database-as-a-service (DBaaS) solutions for a wide variety of analytical and operational workloads.

Database-as-a-service (DBaaS) solutions play an increasingly important role in enterprise data center deployments, where scaling up and down quickly is a high priority. DBaaS offers the technical advantages of accommodating multiple tenants on a wide variety of concurrent workloads in databases ranging from hundreds of megabytes to terabytes in size. It also offers the financial advantages of tighter utilization of infrastructure, with IT paying only for resources actually used.

To capitalize on those advantages, IT organizations now seek new approaches to DBaaS that can meet the escalating demands of online transaction processing

(OLTP), hybrid transactional/analytical processing (HTAP), and advanced analytics. Intel® Select Solutions are verified hardware and software stacks optimized across

compute, storage, and networking resources for specific workloads, such as DBaaS. Built on Intel® Xeon® Scalable processors, Intel Select Solutions help ensure enterprises get the performance, agility, and security they require.

Microsoft SQL Server as a DBaaS Offering

Many organizations extend their Microsoft SQL Server* deployments to use SQL Server as part of their DBaaS solutions. SQL Server provides the high performance, robust security, and flexibility in programming languages expected in a DBaaS environment. In addition to supporting in-memory database capabilities across all workloads, SQL Server offers in-database advanced analytics using SQL Server Machine Learning Services. SQL Server handles the workloads and user requirements in verticals as varied as IT services, manufacturing, retail and ecommerce, healthcare, education, energy, and infrastructure.

Under ordinary database workloads, the traditional way to scale up 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. Simply adding more DRAM does not address all of the performance needs of multi-tenancy and enterprise private cloud deployments, nor does it offer a solution when a legacy version of SQL Server falls out of support.

Intel Select Solutions for SQL Server on Windows Server

In 2019, Intel and Microsoft created a second version of the Intel Select Solutions for SQL Server on Windows Server*. Intel Select Solutions for SQL Server on Windows Server are aligned with the building-block approach to scaling out a DBaaS hosting environment. They are designed to handle the concurrent, variable (for example, operational and analytical) workloads of business users running OLTP, EDW, or both.

Intel Select Solutions for SQL Server on Windows Server  combine Microsoft* software with 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. They offer:

Building blocks for infrastructure that grows to meet the needs of DBaaS
Options for consolidating older SQL Server environments
Benchmarked performance that supports business operations and EDW workloads across a wide variety of verticals
Accelerated time to market with a turnkey solution benchmarked to scale for a variety of workloads

A solid model for long-term compatibility, Intel Select Solutions for SQL Server on Windows Server can help simplify private and public cloud deployments.

Intel’s extensive benchmark testing validates the building- block model of adding and removing infrastructure for easy scaling.

Obtaining further
information by make a contact with our experienced IT staffs.