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
手机扫一扫
移动阅读更方便
你可能感兴趣的文章