SQL Server 2019 Editions Datasheet.pdf

SQL数据库运维

581

3页

2次

2022-05-19

免费下载

SQL Server 2019 editions

Build once and deploy across any SQL Server edition without changing your app

Feature highlights

• Up to 16 cores of CPU

• Up to 64 GBs of memory

• In-memory OLTP and Columnstore

• End-to-end encryption with secure

enclaves

• Full T-SQL surface area

• Support for Linux and Windows

containers

• UTF-8 character encoding

• Data classification and auditing

Feature highlights

• Unlimited cores of CPU

• Unlimited memory

• Industry-leading performance with

unmatched scalability

• Unlimited virtualization benefits

• Petabyte scale data warehousing

• Business critical HA on Windows and

Linux

• Low TCO with free DR replicas

• Access to Power BI Report Server

Feature highlights

• Up to 24 cores of CPU

• Up to 128 GBs of memory

• Data virtualization through PolyBase

• Enhanced in-memory performance

• Automatic intelligent database tuning

• Azure Data Studio with notebook

support

+ Express/web features

+ Standard features

+ Express/web features

Industry leading security, performance and intelligence over

all your data.

What’s new in SQL Server 2019

SQL Server 2019 new features Express/web Standard Enterprise

Compute and

storage

Maximum number of cores 16 24 OS Max

Maximum memory utilized per instance 64 GB 128 GB OS Max

Maximum size 524 PB 524 PB 524 PB

Intelligence

over all your

data

Data virtualization using PolyBase (including additional data sources like Oracle, Teradata, MongoDB, and other

SQL Server databases)

✕ ✕ ✕

Unified AI platform to train and operationalize models in SQL Server ML Services ✕ ✕

Choice of

language and

platform

Compatibility certification ✕ ✕ ✕

UTF-8 support ✕ ✕ ✕

Support for SQL Server Java extension ✕ ✕ ✕

Industry-

leading

performance

and availability

Free DR replicas in Azure and on-premises ✕ ✕

Intelligent QP features: Scalar UDF inlining, table variable deferred compilation, approximate count distinct, and

automatic tuning

✕ ✕

Intelligent QP features: row mode memory grant feedback and batch mode for row store ✕

Automatic read-write connection re-routing

In-Memory Database: memory-optimized tempdb ✕

In-Memory Database: Persistent Memory support ✕ ✕

Secure and

reliable

Always Encrypted with secure enclaves

✕ ✕ ✕

Transparent database encryption

✕ ✕

Data classification and auditing

✕ ✕ ✕

Vulnerability assessment ✕ ✕

Quick business

insights

Azure Data Studio to manage SQL Server including support for T-SQL using Notebooks ✕ ✕ ✕

SQL Server Analysis Services Direct Query ✕ ✕

of 3

免费下载

关注

评论