Microsoft SQL Server 2019 Enterprise 2 Cores System

SQL Server 2019 is the latest generation of Microsoft’s data platform that significantly extended its capabilities as a platform for data unification. This release has been enhanced to deliver breakthrough scalability and performance to improve the stability and response time of the database. The addition of support for Linux with the release of SQL Server 2017 provided organizations the flexibility to select Windows or Linux operating systems based on their business and application needs. SQL Server 2019 extends the options for Linux with support for Red Hat Enterprise Linux 8.0 and Ubuntu 18.04.

Intelligent Query Processing

This new feature can improve the performance of existing workloads with minimal implementation effort. There are several approaches for improving performance including row mode memory grant feedback and batch mode on rowstore, among others.

In-Memory Database

Optimizations include the ability to use Persistent Memory (PMEM) for datapages. Because persistent memory is faster than solid-state drives, the database can service I/O requests faster, accelerating performance.