时间：2021-07-01 10:21:17 帮助过：575人阅读
sql server本身是收费的，虽然网上激活码管理较为松散，但使用到生产环境依旧存在风险。 sql server是否存在不付费也能用于生产环境的版本呢？
sql server 各版本中，仅Express版本允许不付费使用到生产环境，但是需要忍受数据库存储最大为10G的限制(数据库大小到达10.5后无法继续扩展)，而且无法关闭用户使用数据后台自动发送给微软的选项。
sqlserver localdb能否不付费用于生产环境版本呢？localdb属于Express版本的一部分，限制与Express版本相同。
下表为sql server各版本比较：
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Maximum compute capacity used by a single instance - SQL Server Database Engine1 | 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 |
| Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Maximum memory-optimized data size per database in SQL Server Database Engine | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Maximum memory utilized per instance of Analysis Services | Operating System Maximum | Tabular: 16 GB MOLAP: 64 GB | N/A | N/A | N/A |
| Maximum memory utilized per instance of Reporting Services | Operating System Maximum | 64 GB | 64 GB | 4 GB | N/A |
| Maximum relational database size | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB |
参考：
https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017
https://docs.microsoft.com/zh-cn/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017
https://stackoverflow.com/questions/29929640/sql-localdb-size-limit-for-non-express-editions
sqlserver各版本比较以及相关限制
标签：微软 sed sockets ade microsoft util 无法 stack head