SQL Server Planning, Pricing and License

 

Server-CALs授權模式

1.需購買的量應該是所有終端用戶的電腦

例如:一台Data warehouse主機 與 一台Web報表主機，但公司有50人或電腦會連進Web報表主機開啟報表，則應該每一台用戶端電腦都需要有CALs授權，Data warehouse主機購買Server授權

2.此授權模式的SQL Server的CPU(Processor)限制只能用到20 cores，如需大量運算或高負載環境可能會有效能不足狀況

Enterprise edition with Server + Client Access License (CAL) licensing is limited to 20 cores per SQL Server instance. (This licensing isn't available for new agreements.) There are no limits under the Core-based Server Licensing model.

Feature Enterprise Standard Web Express with Advanced Services Express Maximum compute capacity used by a single instance - SQL Server Database Engine 1 Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores Maximum compute capacity used by a single instance - Analysis Services or Reporting Services Operating system maximum Limited to lesser of 4 sockets or 24 cores Limited to lesser of 4 sockets or 16 cores Limited to lesser of 1 socket or 4 cores Limited to lesser of 1 socket or 4 cores Maximum memory for buffer pool per instance of SQL Server Database Engine Operating System Maximum 128 GB 64 GB 1410 MB 1410 MB

Editions and supported features of SQL Server 2019

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16

SQL Server edition	Maximum compute capacity for a single instance (SQL Server Database Engine)	Maximum compute capacity for a single instance (AS, RS)
Enterprise edition: Core-based licensing 1	Operating system maximum	Operating system maximum
Developer	Operating system maximum	Operating system maximum
Standard	Limited to lesser of 4 sockets or 24 cores	Limited to lesser of 4 sockets or 24 cores
Express	Limited to lesser of 1 socket or 4 cores	Limited to lesser of 1 socket or 4 cores

1 Enterprise edition with Server + Client Access License (CAL) licensing is limited to 20 cores per SQL Server instance. (This licensing isn't available for new agreements.) There are no limits under the Core-based Server Licensing model.

Compute capacity limits by edition of SQL Server

https://learn.microsoft.com/en-us/sql/sql-server/compute-capacity-limits-by-edition-of-sql-server?view=sql-server-ver16

SQL Server 2019 pricing

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

https://download.microsoft.com/download/f/0/d/f0d7004e-9e39-4991-853b-2aa09e4ce456/SQL%20Server%202019%20%20Licensing%20Datasheet.pdf

SQL Server Failover Cluster Instance只需要買Active Instance的SQL Server License

2022/5詢問零壹，現在規定須再加買3年SA才合規(以前SA一次可以只買一年，現在SA改成一次須買3年)

How much CPU does Microsoft’s SQL Server use?

https://www.heroix.com/blog/how-much-cpu-does-microsofts-sql-server-2016-use-2/