[研究] Microsoft SQL Server 2019 版本比較、授權、定價

[研究] Microsoft SQL Server 2019 版本比較、授權、定價

2019-11-05

SQL Server 2019 於美國 2019-11-04 釋出，部分資訊已有英文畫面，但尚未有中文畫面。

Double click 可以看100% 原始圖

因為官方可能不定時調整，所有資訊以官方網站最新版資訊為準，本網頁資訊僅供參考。

Microsoft SQL Server - 維基百科，自由的百科全書
https://zh.wikipedia.org/wiki/Microsoft_SQL_Server

SQL Server Express - 維基百科，自由的百科全書
https://zh.wikipedia.org/wiki/SQL_Server_Express
SQL Server Express 只支援

• 1顆 CPU or 4 Cores  ( 到 SQL Server 2019 仍如此)
• 單一資料庫大小在 SQL Server 2005 Express和SQL Server 2008 Express 可到 4GB，最新版本的SQL Server 2008 R2 Express ~ SQL Server 2016 Express 最大資料庫 10G  ( 到 SQL Server 2019 仍 10GB )
• 1GB RAM ( 到 SQL Server 2019 仍如此)

基本上商業使用不建議用 Express 版，因為SQL Server Agent沒有作用，不能設定維護計畫，不能每天自動備份資料庫，DB大小受限，能使用的 CPU/core和 RAM受限，效能不佳。

********************************************************************************

SQL Server 2019 Editions Datasheet.pdf
https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison#CP_StickyNav_1

直接下載
https://download.microsoft.com/download/2/9/0/290f991b-5971-42e5-bb2c-81f700622b2e/SQL%20Server%202019%20Editions%20Datasheet.pdf

Double click 可以看100% 原始圖

********************************************************************************
SQL Server 2016, 2017, 2019 比較
https://www.microsoft.com/en-us/sql-server/sql-server-2019-comparison

Features	SQL Server 2019	SQL Server 2017	SQL Server 2016
Intelligence across all your data
Intelligence over All your Data features of SQL Server by SQL Server version
Big Data Clusters	●	○	○
Data virtualization using PolyBase[1]	●	●	●
Database performance
In-memory database: in-memory OLTP	●	●	●
In-Memory Database: Persistent Memory[2]	●	●	●
In-memory database: memory-optimized tempdb	●	○	○
Real-time operational analytics	●	●	●
Intelligent query processing	●	●	○
Intelligent performance	●	○	○
Availability
Always on	●	●	●
Accelerated database recovery	●	○	○
Read scale-out availability groups	●	●	●
Security
Always encrypted	●	●	●
Always encrypted with secure enclaves	●	○	○
Data discovery and classification	●	○	○
Transparent data encryption	●	●	●
Backup encryption support	●	●	●
Encryption at rest and in motion	●	●	●
Dynamic data masking and row-level security	●	●	●
Cloud readiness
Backup to Azure	●	●	●
Disaster recovery to Azure	●	●	●
Optimized virtual machine (VM) images in Azure gallery	●	●	●
Free asynchronous replication on Azure Virtual Machines for disaster recovery	●	○	○
Management and programmability
Linux support	●	●	○
Container support	●	●	○
Kubernetes support	●	○	○
Temporal tables	●	●	●
JSON support	●	●	●
Graph data support	●	●	○
UTF 8 support	●	○	○
Java support	●	○	○
Azure Data Studio to manage SQL Server including support for T-SQL using notebooks	●	●	●
Database compatibility certification	●	●	●
BI and Analytics Support
Integration services managed as a server	●	●	●
Tabular BI semantic model[3]	●	●	●
Master data services[3]	●	●	●
Data quality services[3]	●	●	●
Many-to-many relationships in tabular models	●	○	○
End-to-end mobile BI on any device	●	●	●
SQL Server Analysis Services (SSAS) direct query	●	●	●
Calculation groups in tabular model	●	○	○

********************************************************************************

比較 SQL Server 2019 版本 (尚未提供)

https://www.microsoft.com/en-us/sql-server/sql-server-2019-editions
https://www.microsoft.com/zh-tw/sql-server/sql-server-2019-editions

暫時看 SQL Server 2017 的

********************************************************************************

SQL Server 版本比較 (2008 R2, 2012, 2014, 2016, 2017)
https://www.microsoft.com/en-us/server-cloud/products/sql-server/Comparison.aspx
( 英文版網頁更新較快)

SQL Server 版本比較 (2008 R2, 2012, 2014, 2016, 2017)
https://www.microsoft.com/zh-tw/server-cloud/products/sql-server/Comparison.aspx

所有 SQL Server 版本 | Microsoft
https://www.microsoft.com/zh-tw/server-cloud/products/sql-server-editions/overview.aspx

(下圖)

SQL Server Licensing and Price
https://www.microsoft.com/en-us/server-cloud/products/sql-server/purchasing.aspx
https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing

SQL Server 2019 Pricing
https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing

繁中網頁(尚未提供)
https://www.microsoft.com/zh-tw/sql-server/sql-server-2019-pricing

Editions	Open no level price (US$)	Licensing model	Channel availability
Enterprise	$13, 748	2 core pack	Volume licensing, hosting
Standard - per core	$3,586	2 core pack	Volume licensing, hosting
Standard - server	$899	Server[2]	Volume licensing, hosting
Standard - CAL	$209	CAL	Volume licensing, hosting
Developer	Free	Per user	Free download
Web	See your hosting partner for pricing	Not applicable	Hosting only
Express	Free	Not applicable	Free download

商業授權模式有 根據 CPU Cores/Pack 方式，或 Server + CAL 方式2種。

• CPU Cores/Pack 販售以 Pack 為單位，每個 Pack 有2個 CPU Cores 授權。

********************************************************************************

Read the SQL Server 2019 licensing data sheet
Read the SQL Server 2019 licensing guide
https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing#CP_StickyNav_1


(下圖) 授權模型 Licensing Model

(下圖) SQL Server 2019 with SA (Software Assurance) 的優點

(下圖) 個別虛擬機器 (Individual Virtual Machine ) or 容器 (Container)

安裝於 VM，如果 vCores 少於4，至少要買 4 Cores 授權；高於4則，則依據 vCores 數買。

SQL Server 2019 Developer Edition is a free product, available for download at the SQL Server Application Development site:
https://www.microsoft.com/en-us/sql-server/application-development

(待續)

相關

[研究] Windows Server 2019 版本比較、授權、定價
https://shaurong.blogspot.com/2018/12/windows-server-2019.html

[研究] Microsoft SQL Server 2017 版本比較、授權、定價
https://shaurong.blogspot.com/2017/09/microsoft-sql-server-2017.html

[研究] MSDN 訂閱 ( Visual Studio 2019 ) 版本比較、授權、定價
https://shaurong.blogspot.com/2019/11/msdn-visual-studio-2019.html

[研究] Visual Studio Community 社群版授權
https://shaurong.blogspot.com/2019/10/visual-studio-community.html

[研究] VMware 與 VirtualBox 授權 (Licensing)
https://shaurong.blogspot.com/2017/07/vmware-virtualbox-licensing.html

[研究] Apose.PDF 訂價與授權定價, 訂價, 授權
https://shaurong.blogspot.com/2019/11/aposepdf.html

[研究] Froala Editor 訂價與授權
https://shaurong.blogspot.com/2019/11/froala-editor.html

Windows Server 2019
https://zh.wikipedia.org/wiki/Windows_Server_2019

[研究] Windows Server 2016 版本比較、授權、定價
http://shaurong.blogspot.com/2017/02/windows-server-2016.html

[研究] SQL Server 2016 版本比較、授權、定價
http://shaurong.blogspot.com/2016/06/sql-server-2016_8.html

[研究] MSDN Subscriptions 訂閱者授權
http://shaurong.blogspot.com/2016/05/msdn-subscriptions.html

[研究] Windows Server 2012 R2 授權資訊
http://shaurong.blogspot.tw/2015/10/windows-server-2012-r2_19.html