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 Database Mirroring 資料庫鏡像

SQL Server Database Mirroring 資料庫鏡像