当前位置:Gxlcms > 数据库问题 > sqlserver各版本比较以及相关限制

sqlserver各版本比较以及相关限制

时间: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   

人气教程排行