2020年12月21日 星期一

SQL Server Express

 SQL Server Express


Scale limits

Feature

Express with
Advanced Services

Express

Maximum compute capacity used by a single instance - SQL Server Database Engine1

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

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

1410 MB

1410 MB

Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine

352 MB

352 MB

Maximum memory-optimized data size per database in SQL Server Database Engine

352 MB

352 MB

Maximum memory utilized per instance of Analysis Services

N/A

N/A

Maximum memory utilized per instance of Reporting Services

4 GB

N/A

Maximum relational database size

10 GB

10 GB

database size 10GB (the limit is on the data file, it doesn't include log files)


Editions and supported features of SQL Server 2019 (15.x)

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15

Microsoft® SQL Server® 2019 Express

https://www.microsoft.com/en-us/download/details.aspx?id=101064

SQL Server 下載| Microsoft

https://www.microsoft.com/zh-tw/sql-server/sql-server-downloads


沒有留言:

SQL Server Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...